Re: Automatic Client Failover - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Automatic Client Failover
Date
Msg-id 14564.1217891597@sss.pgh.pa.us
Whole thread Raw
In response to Re: Automatic Client Failover  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Automatic Client Failover  (Dimitri Fontaine <dfontaine@hi-media.com>)
Re: Automatic Client Failover  ("Greg Stark" <greg.stark@enterprisedb.com>)
Re: Automatic Client Failover  (Markus Wanner <markus@bluegap.ch>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: IN vs EXISTS equivalence
Next
From: Hannu Krosing
Date:
Subject: Re: Automatic Client Failover