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

Tatsuo Ishii ishii at sraoss.co.jp
Thu Dec 5 13:31:23 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.

Yes, I agree that there's no reason why this could not work. (I assume
each PostgreSQL has its own different database directories).

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list