[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
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
More information about the pgpool-general
mailing list