[pgpool-general: 4144] Re: pcp commands

[Tatsuo Ishii]

> 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