Thread: pgpool redundancy question

Hi List;

It seems that in a replication scenario pgpool becomes the single point of
failure, i.e. if we loose the pgpool box were dead. Any thoughts,
suggestions, best practices, etc per creating redundancy in the pgpool layer?

I've posted to the pgpool list as well but I wanted to get some thoughts on
how the postgresql community has dealt with this...


Thanks in advance

> Hi List;
>
> It seems that in a replication scenario pgpool becomes the single point of
> failure, i.e. if we loose the pgpool box were dead. Any thoughts,
> suggestions, best practices, etc per creating redundancy in the pgpool layer?
>
> I've posted to the pgpool list as well but I wanted to get some thoughts on
> how the postgresql community has dealt with this...

Try pgpool-HA.
http://pgfoundry.org/projects/pgpool/
--
Tatsuo Ishii
SRA OSS, Inc. Japan