Re: Automatic Client Failover - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Automatic Client Failover
Date
Msg-id 200808041439.29469.josh@agliodbs.com
Whole thread Raw
In response to Automatic Client Failover  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Automatic Client Failover  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
On Monday 04 August 2008 14:08, Simon Riggs wrote:
> When primary server fails, it would be good if the clients connected to
> the primary knew to reconnect to the standby servers automatically.
>
> We might want to specify that centrally and then send the redirection
> address to the client when it connects. Sounds like lots of work though.
>
> Seems fairly straightforward to specify a standby connection service at
> client level: .pgreconnect, or pgreconnect.conf
> No config, then option not used.

Well, it's less simple, but you can already do this with pgPool on the 
client machine.


-- 
--Josh

Josh Berkus
PostgreSQL
San Francisco


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Mini improvement: statement_cost_limit
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Automatic Client Failover