Postgres Pro
Downloads
Home   >   mailing lists

Re: replication_timeout does not seem to be working - Mailing list pgsql-admin

From Greg Smith
Subject Re: replication_timeout does not seem to be working
Date
Msg-id 4E2FB465.90406@2ndQuadrant.com
Whole thread Raw
In response to Re: replication_timeout does not seem to be working  (A J <s5aly@yahoo.com>)
Responses Re: replication_timeout does not seem to be working  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-admin
Tree view
On 07/22/2011 12:11 PM, A J wrote:
Basically I wish my synchronous write transaction to not wait indefinitely when the synchronous standby servers are not available. But rather a response returned back to client that write could not be successful, after trying for 'n' seconds. How can that be accomplished ?

You might be able to get what you want here by setting statement_timeout to 'n' seconds when doing a write transaction.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us

pgsql-admin by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: synchronous_commit and wal_writer_delay
Next
From: Benjamin Knoth
Date:
Subject: HA-Fedora repository with HA-Postgresql