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 >