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

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(dot)balaji(at)verse(dot)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
>