Re: Improving Availability

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