synchronous replication: blocking commit on the master - Mailing list pgsql-general

From Jameison Martin
Subject synchronous replication: blocking commit on the master
Date
Msg-id 1330389386.71455.YahooMailNeo@web39401.mail.mud.yahoo.com
Whole thread Raw
Responses Re: synchronous replication: blocking commit on the master
List pgsql-general
I have observed that a commit on a replication master hangs if there are no slaves to communicate with if synchronous replication is enabled. I believe I have seen a posting that this behavior is deliberate.

In my environment I'd prefer to have the master continue processing transactions if there is a failure at the slave. Questions:
  • is there any way to allow the master proceed if the slave is unavailable (perhaps a configuration parameter I'm missing)?
  • if not, is there any ideological objection to allowing the master to continue for users that would prefer that behavior?
Thanks.

pgsql-general by date:

Previous
From: Jameison Martin
Date:
Subject: "canceling autovacuum time"
Next
From: Jameison Martin
Date:
Subject: xlog corruption