On Wed, Jul 27, 2011 at 3:47 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin