[pgpool-general: 4821] Re: Incosistency between "show pool_nodes" and pcp_node_info.

Tatsuo Ishii ishii at postgresql.org
Tue Jul 26 08:01:06 JST 2016

>> The status "1" means no one is connecting to the node for now. Once
>> you connect to pgpool, the status is changed to "2".
>> So if you execute "show pool_nodes" then pcp_node_info, you don't see
>> the difference.  However if you execute pcp_node_info then "show
>> pool_nodes", you will see the difference.
> I checked, and this is not the case. pcp_node_info shows "1" for all
> active nodes even when there's multiple active connections with running
> queries.

Does not reproduce here. What version of pgpool-II are you using?
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list