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

Sun Jul 15 03:54:45 JST 2012

Philip thank you very much for your answer. Now it's working.

Regards.
________________________________________
From: Philip Hofstetter [phofstetter at sensational.ch]
Sent: Saturday, July 14, 2012 1:40 PM
To: Lazáro Rubén García Martínez
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 734] Error with listen_addresses and watchdog in pgpool-II-3.2beta2

Hi,

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

Philip

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com