[pgpool-general: 4153] Re: pcp commands

Tatsuo Ishii ishii at postgresql.org
Thu Oct 29 08:38:32 JST 2015


> pcp_node_count & pcp_attach_node  & pcp_detach_node is working...but
> pcp_pool_ststus & pcp_node_info gets errors...

> *pcp_pool_status*
> 
> template1=# select pcp_pool_status('192.168.15.59',500,9898,'user','pass');
> ERROR:  set-valued function called in context that cannot accept a set

As the error message said, it's a set returning function and you
should do something like:

select * from pcp_pool_status('192.168.15.59',500,9898,'user','pass');

> *pcp_node_info*
> 
> template1=# select pcp_node_info(0,'192.168.15.59',500,9898,'user','pass');
> The connection to the server was lost. Attempting reset: Failed.
> !>

Will look into this.

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