Thank you all for the quick replies. John Wiencek On 1/13/16, 2:43 PM, "Thomas Munro" <thomas.munro@xxxxxxxxxxxxxxxx> wrote: >On Thu, Jan 14, 2016 at 9:34 AM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> >wrote: >> On 01/13/2016 12:28 PM, jwiencek3@xxxxxxxxxxx wrote: >>> >>> Is it possible to set up synchronous replication to more that one node >>> in a cluster? Or, am I limited to one synchronous node and one >>> asynchronous node? >> >> >> Yes you can have N number of synchronous slaves. However, be careful. >>It can >> be a huge performance hit. > >Note that only one of the listed standbys is a synchronous standby at >any given time though. That is, when you commit, the primary server >will wait just for that one server to report that it has fsync'ed the >WAL. (There is a patch being developed to change that so that you >might be able to wait for more than one in a future release). > >-- >Thomas Munro >http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
