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