[pgpool-general: 7646] Can PGPool manage multiple Postgres Clusters on every node?

Luca Maranzano liuk001 at gmail.com
Mon Jul 26 01:02:43 JST 2021


we are setting up a 3 nodes clusters similar to this one:


we are using CentOS 7.9 physical nodes with PGPool 4.2 and PostgreSQL 12.

We need to have on every node 4 PostgreSQL instances (1 for prod, 1 for
pre-production, 1 for test and 1 for dev), all of them must be in streaming
replication with the other 2 nodes.

Can PGPool manage such configuration? From the documentation we didn't find
any reference.
We are thinking to create 4 different pgpool instances, each one with its
set of files and tcp port, is this a supported configuration?

Thanks in advance for your help.
Best regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210725/4372b5f0/attachment.htm>

More information about the pgpool-general mailing list