[pgpool-general: 735] Re: Error with listen_addresses and watchdog in pgpool-II-3.2beta2

Philip Hofstetter phofstetter at sensational.ch
Sun Jul 15 03:10:57 JST 2012


On Sat, Jul 14, 2012 at 8:25 PM, Lazáro Rubén García Martínez
<lgarciam at vnz.uci.cu> wrote:

> I am configuring pgpool for using the watchdog functionality. The virtual IP manage be watchdog is
> When I configure listen_addresses property for listen only over the virtual ip, pgpool
> is not start. I configure listen_addresses like this because at this way I have the warranty that the
> users only may connect to pgpool, through the vip.

In order to listen on an address that's not currently configured to
any interface, you have to enable ip_nonlocal_bind (I'm assuming
you're using linux):

echo 1 > /proc/sys/net/ipv4/ip_nonlocal_bind

If it's a newer linux distro, add

net.ipv4.ip_nonlocal_bind = 1

to /etc/sysctl.conf

You'd still have to bring up another address though (it can be totally
private) for the various hosts to see each other even when they don't
have the virtual address for the watchdog to work correctly.


More information about the pgpool-general mailing list