[Pgpool-general] 3 Servers needed?

[Tatsuo Ishii]

> Hello!
> 
> I am about to set up a postgresql replication system and would like to 
> try out pgpool.
> 
> But I couldn't find anywhere one important information:
> Do I need a seperate machine to run pgpool? Or is it possible to run it 
> on both - the primary and secondary pgsql machine?
>
> I mean in case of a total failure of one machine the switchover has to 
> be managed somehow. So if the primary pgsql server goes down (with its 
> pgpool) is it possible that a (second running) pgpool instance on the 
> secondary server takes over?

If you have a load balancer in front of those machines, that should be
possible. I think heartbeat could handle too this kind of situation but
personaly no experience with it.
--
Tatsuo Ishii
SRA OSS, Inc. Japan