Re: replication_timeout does not seem to be working

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication_timeout does not seem to be working
Date: 2011-07-27 06:47:01
Message-ID: 4E2FB465.90406@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Knoth 2011-07-27 08:41:28 HA-Fedora repository with HA-Postgresql
Previous Message Jaime Casanova 2011-07-26 22:50:43 Re: synchronous_commit and wal_writer_delay