Re: Automatic Client Failover

"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> On Mon, Aug 4, 2008 at 5:39 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> Well, it's less simple, but you can already do this with pgPool on the
>> client machine.

> Yeah, but if you have tens or hundreds of clients, you wouldn't want
> to be installing/managing a pgpool on each.

Huh?  The pgpool is on the server, not on the client side.

There is one really bad consequence of the oversimplified failover
design that Simon proposes, which is that clients might try to fail over
for reasons other than a primary server failure.  (Think network
partition.)  You really want any such behavior to be managed centrally,
IMHO.
        regards, tom lane