From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-admin@postgresql.org
Subject: Re: replication_timeout does not seem to be working
Date: Wed, 27 Jul 2011 02:47:01 -0400
Message-ID: <4E2FB465.90406@2ndQuadrant.com> (raw)
In-Reply-To: <1311351085.55818.YahooMailNeo@web120018.mail.ne1.yahoo.com>
References: <1311279255.75976.YahooMailNeo@web120016.mail.ne1.yahoo.com>
<CAHGQGwH=7eHwbjtnO25T=AH9-D8USov1_ZvrYz7bx+2SRaNWkA@mail.gmail.com>
<1311351085.55818.YahooMailNeo@web120018.mail.ne1.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndQuadrant.com
Subject: Re: replication_timeout does not seem to be working
In-Reply-To: <4E2FB465.90406@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox