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

synchronous_commit is "on"

Thanks
VB

On Thu, Feb 2, 2012 at 12:31 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)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(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
>>
>
>