[Pgpool-general] pgpool-ii health checking

[Yoshiyuki Asaba]

Hi,

From: "Oleg Laktionov" <olaktionov at gmail.com>
Subject: Re: [Pgpool-general] pgpool-ii health checking
Date: Tue, 13 Nov 2007 14:40:44 +0300

> Pgpool successfully realized the failure...
> 
> Further I start the Postgresql server on the node tmpwc ...
> 
> 2007-11-13 13:44:04 DEBUG: pid 25879: I am 25879
> 2007-11-13 13:44:14 LOG:   pid 24485: starting health checking
> 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 0 the DB node status: 2
> 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 1 the DB node status: 2
> 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 2 the DB node status: 3
> 2007-11-13 13:44:24 LOG:   pid 24485: starting health checking
> 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 0 the DB node status: 2
> 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 1 the DB node status: 2
> 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 2 the DB node status: 3
> 
> Nevertheless pgpoll does not see this event... Ordinary connection to the
> tmpwc works fine...

You need to perform pcp_attach_node command. pgpool do not reattach a
node in health checking.


> And I have some more question. Can I disable failover mode for the pgpool?
> For example I wish to use only replica.test.sportbox.ru as the master node.
> Is it possible anyhow?

No, if a master node is down, pgpool determines a new master node.

--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp

> 
> 
> 2007/11/13, Yoshiyuki Asaba <y-asaba at sraoss.co.jp>:
> >
> > Hi,
> >
> > From: "Oleg Laktionov" <olaktionov at gmail.com>
> > Subject: Re: [Pgpool-general] pgpool-ii health checking
> > Date: Mon, 12 Nov 2007 10:37:06 +0300
> >
> > > I use pgpool-ii-1.3.
> >
> > Hmm... I can't reproduce it.
> > Could you show us pgpool's error log?
> >
> > Regards,
> > --
> > Yoshiyuki Asaba
> > y-asaba at sraoss.co.jp
> >
> >
> > >
> > >
> > > 2007/11/12, Yoshiyuki Asaba <y-asaba at sraoss.co.jp>:
> > > >
> > > > Hi,
> > > >
> > > > From: "Oleg Laktionov" <olaktionov at gmail.com>
> > > > Subject: [Pgpool-general] pgpool-ii health checking
> > > > Date: Fri, 9 Nov 2007 16:19:43 +0300
> > > >
> > > > > About pgpool-ii...
> > > > > Can anybody explain me the mechanism of performing backend health
> > > > checking?
> > > > > Pgpool-ii successfully understands that some of the backends is
> > down.
> > > > > Nevertheless when some of the backends is online again, pgpool does
> > not
> > > > see
> > > > > this event.
> > > > > Only restart of the pgpool-ii helps...
> > > >
> > > > Which version do you use?
> > > >
> > > > --
> > > > Yoshiyuki Asaba
> > > > y-asaba at sraoss.co.jp
> > > > _______________________________________________
> > > > Pgpool-general mailing list
> > > > Pgpool-general at pgfoundry.org
> > > > http://pgfoundry.org/mailman/listinfo/pgpool-general
> > > >
> > >
> > >
> > >
> > > --
> > > best regards,
> > > Oleg Laktionov
> >
> 
> 
> 
> -- 
> best regards,
> Oleg Laktionov