[pgpool-general: 2602] PGPool watchdog not releasing shared IP

[Chris Mann]

Hello all,

I’ve two pgpools, one on it’s own server and one on a database server. When pgpool gets shutdown with a smart shutdown, it seems that pgpool can’t release the shared IP, and this results in hung state between the two, since the app servers are looking to that IP address. What I see in the logs is this:

2014-03-06 20:04:31 DEBUG: pid 10686: wd_IP_down: not delegate IP holder

It’s almost as if both PGPools are trying to grab that delegate IP address.

I’ve worked with my VSP, and according to them, what I need to do is basically run a cron script to ping that IP address before the delegate IP address will float over to the other pgpool server. This is kind if clunky, is there some way to have pgpool perform this as part of it’s watchdogging?

Thanks!