Hi, From: "Oleg Laktionov" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > > 2007/11/13, Yoshiyuki Asaba <[EMAIL PROTECTED]>: > > > > Hi, > > > > From: "Oleg Laktionov" <[EMAIL PROTECTED]> > > 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 > > [EMAIL PROTECTED] > > > > > > > > > > > > > 2007/11/12, Yoshiyuki Asaba <[EMAIL PROTECTED]>: > > > > > > > > Hi, > > > > > > > > From: "Oleg Laktionov" <[EMAIL PROTECTED]> > > > > 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 > > > > [EMAIL PROTECTED] > > > > _______________________________________________ > > > > Pgpool-general mailing list > > > > [email protected] > > > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > > > > > > > > > > > > -- > > > best regards, > > > Oleg Laktionov > > > > > > -- > best regards, > Oleg Laktionov _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
