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

[Philip Hofstetter]

Be really careful to not only do the sysctl change but also make sure that
all the machines can reach each other even if they don't have the shared IP.

Otherwise you will create a very nasty loop of constantly failing over
pgpools.

You could assign an IP address from a different network than the one
clients use to all the interfaces

That's what I meant with the second part of my answer.

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

> 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
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120714/c1966cb7/attachment.html>