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

On Tue, Feb 14, 2012 at 8:09 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
>