[pgpool-general: 2792] Re: ask pgpool for status

[Granthana Biswas]

Attila,

If you want to check the individual node status, then pcp_node_info is
useful.

/<pgpool_bin_path>/pcp_node_info 10 localhost pcp_port postgres password 0
| awk '{print$3}']

2 means it's up and connected.



Regards,
Granthana


On Wed, Apr 23, 2014 at 3:07 PM, Attila Heidrich
<attila.heidrich at gmail.com>wrote:

> Dear guys!
>
> What command or script do u use for asking the pgpool's current status?
> I have written a small wrapper for pcp. Since pcp is available on all
> nodes running pgpool2, I have setup the target IP for 217.0.0.1.
>
> Am I right, that I should have the same result asking the same thing on
> all the nodes? Or should I use the common address, not the local one? It's
> a good way to have consistent results (mainly) all the time for sure, but
> what's recommended?
>
>
> regards,
> Attila
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140423/6214f29b/attachment.html>