[Pgpool-general] multiple instances of pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Fri Jul 24 04:13:07 UTC 2009


> We are wondering, whether it would be possible to run pgpool in a J2EE cluster szenario by installing a pgpool instance on each node of the cluster. Pgpool should then replicate the database synchroniously.
> 
> Would this work? Can pgpool run multiple instances against the same databases? Or are we restricted to a single pgpool instance? 

Yes, it's definitely possible. One thing you have to care is, the
network connection between J2EE cluster(where pgpool-II lives) and
PostgreSQL should be very reliable.

> Sorry for bothering you, we simply did not find the information needed in the documentation. We did some testing, but the results are not yet clear.

Sorry for the unclearness of docs. I will improve them. BTW do you
have any problem in your testing?
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list