[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

More information about the pgpool-general mailing list