[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