Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.balaji@xxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux