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