Re: Improving Availability - Mailing list pgsql-general

From Richard Huxton
Subject Re: Improving Availability
Date
Msg-id 43A04818.4000207@archonet.com
Whole thread Raw
In response to Re: Improving Availability  (Guido Neitzer <guido.neitzer@pharmaline.de>)
List pgsql-general
Guido Neitzer wrote:
> On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote:
>
>> I'd be tempted to look at pgpool sitting between your application and
>> the database, and then replication from the one machine to the other.
>
> Right, I thought the same, BUT: I have two application servers (one on
> each machine) connecting to a network URL via JDBC. When pgpool is
> involved, I assume it only runs on one server, right?
>
> Or can I have pgpool running on both servers, each knowing about the two
> servers and the applications just connect to "localhost"?

That's the sort of thing I was thinking of. Keep the application
ignorant of the actual setup.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: Improving Availability
Next
From: Scott Marlowe
Date:
Subject: Re: Improving Availability