[pgpool-hackers: 3471] Multiple pgpool instance on a single server

Max Hoarau max.hoarau33 at orange.fr
Thu Dec 5 01:17:40 JST 2019


Hei all,
i have searched all over the web, but did not find the answer.
Just found a beginning of answer to my question on stack overflow.
 
I was wondering if there is any possibility to run multiple instance of pgpool
on the same server.
 
lets says i have the following : 
 
Postgresql  : 
- PGserver1 : 
running postgresql on port 65432
running postgresql on port 65433
 
- PGserver2
replication from PGServer1 port 65432
replication from PGServer1 port 65433
 
So basicaly, two postgresSql cluster running on PGServer1 on two different ports, 
and each of them is replicated (streaming replication) on PGServer2
 
On two other separate servers, i would like to have one pgpool instance managing the postgresql cluster running on port 65432
And an other instance of pgpool managing the postgresql cluster running on port 65433, on two differents VIP.
 
On stack overflow, they says that there is no reason why this could not work, but i would like a confirmation,
and this is the only place where i found the beginning of an answer to this question.
 
Thanks for your help and best reagrds
Max
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20191204/53b3337d/attachment.html>


More information about the pgpool-hackers mailing list