Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue - Mailing list pgsql-general

From Venkat Balaji
Subject Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue
Date
Msg-id CAFrxt0ihguq0xMYT9NDXj2DxQ7xZHnK8BnHX5br_S-WtUoH-GQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view
synchronous_commit is "on"

Thanks
VB

On Thu, Feb 2, 2012 at 12:31 PM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
What is the value of synchronous_commit ?

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Thu, Feb 2, 2012 at 12:21 PM, Venkat Balaji <venkat.balaji@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


pgsql-general by date:

Previous
From: Gregg Jaskiewicz
Date:
Subject: Re: Why Hard-Coded Version 9.1 In Names?
Next
From: Dean Rasheed
Date:
Subject: Re: Audtiting, DDL and DML in same SQL Function