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

On Wed, Jul 27, 2011 at 3:47 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> 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.

No. statement_timeout cannot cancel the transaction whose commit record has
already been written to local disk.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center