synchronous_commit is "on" Thanks VB
On Thu, Feb 2, 2012 at 12:31 PM, Raghavendra < raghavendra....@enterprisedb.com> wrote: > What is the value of synchronous_commit ? > > --- > Regards, > Raghavendra > EnterpriseDB Corporation > Blog: http://raghavt.blogspot.com/ > > > > On Thu, Feb 2, 2012 at 12:21 PM, Venkat Balaji <venkat.bal...@verse.in>wrote: > >> Hello, >> >> I was testing the Postgres-9.1.1 synchronous streaming replication on our >> UAT system. >> >> Without synchronous replication, everything was working fine. >> >> But, when i enabled synchronous_replication_names='*', the "create table" >> started hanging for long time. >> >> When i pressed "Ctrl+C" i got the following message - >> >> Cancel request sent >> WARNING: canceling wait for synchronous replication due to user request >> DETAIL: The transaction has already committed locally, but might not >> have been replicated to the standby. >> CREATE TABLE >> >> Can someone please help us ? >> >> Thanks >> VB >> > >