[pgpool-general: 3165] Re: Determining which instance is the master
Tatsuo Ishii
ishii at postgresql.org
Wed Sep 17 07:35:07 JST 2014
> After a couple of rounds of testing this morning, I started wondering
> which pgpool instance was the master of the cluster. I looked at the
> pcp commands and I see how to promote one instance to master, but
> nothing really struck me as indicating which instance was currently
> the master, that is unless I missed seeing that in pcp_node_info. Is
> there a way to determine that programmatically?
Probably "show pool_nodes" is what you want.
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-general
mailing list