[pgpool-general: 4146] Re: pcp commands

[Shay Cohavi]

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/20151025/c484fec7/attachment.html>