[GENERA]: Postgresql-9.1.1 synchronous replication issue

[Venkat Balaji <venkat.balaji@xxxxxxxx>]

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