[pgpool-general: 4425] Re: watchdog - how to determine active / stanby states for each pgpool node

[Gervais de Montbrun]

Whoa! pcp_watchdog_info seems to have changed a lot in 3.5...
The documentation looks completely different than what i expected to see
I'm assuming this is the new output from 3.5:
	http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_watchdog_info

I hope that old format can still be used as I call pcp_watchdog_info in my nagios and wrapper scripts...

In 3.4.x, the node that is holding the virtual ip returns a status code of "3"
	example:
pcp_watchdog_info 10 <virtual-ip-hostname> 9898 postgres <password>
cara0 5432 9000 3
	or
pcp_watchdog_info 10 <virtual-ip-hostname> 9898 postgres <password> 0
cara1 5432 9000 2

The result is in the following order:

	• hostname
	• port number for pgpool-II
	• port number for watchdog
	• watchdog Status

Status is represented by a digit from [1 to 4]:

	1. watchdog is not started
	2. Standby: not holding the virtual IP
	3. Active: holding the virtual IP
	4. Down

Hope that helps!

Cheers,
Gervais



> On Feb 9, 2016, at 3:28 PM, Travis Kirstine <tkirstine at firstbasesolutions.com> wrote:
> 
> Is there a way to determine the pgpool node status when running in watchdog mode or which pgpool node is using the virtual ip?
> thanks
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net>
> http://www.pgpool.net/mailman/listinfo/pgpool-general <http://www.pgpool.net/mailman/listinfo/pgpool-general>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20160209/d4573d17/attachment.htm>