[pgpool-general: 3165] Re: Determining which instance is the master
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.
SRA OSS, Inc. Japan
More information about the pgpool-general