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

Granthana Biswas granthana at zedo.com
Wed Apr 23 18:48:33 JST 2014


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

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

2 means it's up and connected.


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
> 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>

More information about the pgpool-general mailing list