On Tuesday, February 14, 2012 4:21:22 am Venkat Balaji wrote: > Hello, > > Disaster Recovery testing for Synchronous replication setup - > > When the standby site is down, transactions at the production site started > hanging (this is after the successful setup of synchronous replication). > > We changed synchronous_commit to 'local' to over-come this situation. > > - No transactions are hanging at the production site even when the standby > is down > - Standby is automatically getting synced when it is back up again. > > Can someone let us know if there are any "-ve" effects of putting > synchronous_commit='local' ?? > > I am assuming that this as good as putting "synchronous_commit=on" on an > stand-alone system. It would seem you are really after streaming replication(which is asynchronous) more than synchronous replication. I have not used synchronous replication enough to be sure, but I think by setting synchronous_commit='local' you are basically turning the system into a straight streaming(asynchronous) system anyway. > > We need to get this setup live on production shortly. > > Thanks > VB -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
