[pgpool-general: 3166] Re: Determining which instance is the master

Tatsuo Ishii ishii at postgresql.org
Wed Sep 17 10:11:52 JST 2014

> Arrigato, Ishii-san. I'll look at that next morning. I'm assuming this
> is a SQL command, am I correct?


> Also, I noticed later today that the
> system with the postgresql instance that I stopped in order to induce
> a failover test, came back up as standby server, but pgpool's
> pcp_node_info showed it as status = 3 until I executed pcp_attach_node
> to put it back into the cluster. The status 3 didn't bother me, but I
> was wondering why that system was promoted back to master immediately
> after running pcp_attach_node, or why even it lost master status. (I
> had only stopped postgresql on that system, not pgpool.)
> Jay

Can you tell what you did exactly. I even not sure you shutdown
primary PostgreSQL or standby PostgreSQL.

> On 9/16/2014 6:35 PM, Tatsuo Ishii wrote:
>>> 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