[Pgpool-general] Migrating from single postgresql to pgpool with multiple postgresql nodes

[Brent Thomson]

Harold Lim wrote:
> Thanks Gerd.
> 
> Another Question. I currently have Java servlets that talks to postgresql using JDBC.
> 
> With pgpool, how does it work now? What address should I change the jdbc address to?

Point it at the pgpool machine. Everything should run through there now.
In fact, you'll probably want to modify your hba files on your
postgresql nodes to disallow connections from any machine other than the
pgpool controller.

-Brent