Search Postgresql Archives

Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux