[pgpool-general: 3533] Re: Find current PGpool master node

Tatsuo Ishii ishii at postgresql.org
Tue Mar 17 09:53:10 JST 2015

> Hello all,
> Is there a command (show or pcp?) to find the current PGpool master node?
> I am using 3.3.1 (about to upgrade) with two PGpool nodes running active /
> active behind an AWS ELB load balancer.
> I am not using a VIP, instead relying on the ELB to see that a PGpool has
> gone down and take it out of the load a balancing group.

Just out of the curiosity, why do you want to know which one is master?

Also I'm interested in your set up because pgpool-II + AWS ELB load
balancer configuration has some users and I would like to enhance
pgpool-II to better serve with the configuration. I have not yet found
the best practice of pgpool-II on AWS.

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

More information about the pgpool-general mailing list