On Tue, Feb 14, 2012 at 8:09 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:
> 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. > Yeah. Its a kind of asynchronous. All i wanted is as follows - 1 > > > > > We need to get this setup live on production shortly. > > > > Thanks > > VB > > -- > Adrian Klaver > adrian.kla...@gmail.com >