[pgpool-general: 4150] Re: pcp commands

[Shay Cohavi]

hi,
I had managed to compile and install the pgpool_adm extension!!
but,i've got errors (connection errors):

select pcp_node_info(1,'*pgpool_vip*',10,*pcp_port* ,'*pcp_usr*','*pcp_pass*
');

template1=# select
pcp_node_info(1,'192.168.15.59',10,9898,'myusr','mypass');
FATAL:  unable to read data from DB node 1
DETAIL:  EOF encountered with backend
FATAL:  unable to read data from DB node 1
DETAIL:  EOF encountered with backend
The connection to the server was lost. Attempting reset: Failed.

any ideas???

Thanks...




On Sun, Oct 25, 2015 at 8:16 PM, Shay Cohavi <cohavisi at gmail.com> wrote:

> Thanks a lot!!!
> l'll check it
>
> On Sun, Oct 25, 2015 at 10:02 AM, Tatsuo Ishii <ishii at postgresql.org>
> wrote:
>
>> > Hi,
>> > Is there any why to execute pcp command:
>> > pcp_detach_node...
>> > pcp_attach_node...
>> >
>> > via SQL functions? or via http service (not pgpool Admin GUI)??
>>
>> There's a set of SQL functions called "pgpool_adm" in the source tree.
>> See src/sql/pgpool_adm.
>>
>> One you install the pgpool_adm extesion, you can do;
>>
>> select pcp_attach_node(1, 'localhost', 0, 11001, 'username', 'password');
>>
>> arg1: node id to be attached (int)
>> arg2: host name on which pcp server runs on (text) usually 'localhost'.
>> arg3: time out value (int). Currently ignored and whatever value can be
>> accepted.
>> arg4: port number which pcp server listens (int)
>> arg5: pcp user name (text)
>> arg6: pcp password (text)
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151027/291b2669/attachment-0001.html>