[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