[pgpool-hackers: 1123] Re: [pgpool-general: 4144] Re: pcp commands
Tatsuo Ishii
ishii at postgresql.org
Mon Oct 26 10:41:04 JST 2015
Today I found that there's no documentation for src/sql/pgpool_adm.
This is shame and I think we should add the doc by the release of 3.5.
I will add this to our TODO list for pgpool-II 3.5.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-hackers
mailing list