[pgpool-hackers: 1123] Re: [pgpool-general: 4144] Re: pcp commands

[Tatsuo Ishii]

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