[pgpool-general: 2788] Re: timeout Watchdog

[Yugo Nagata]

Hi,

On Tue, 22 Apr 2014 16:42:42 -0300
Thomaz Luiz Santos <thomaz.santos at gmail.com> wrote:

> I changed the parameters,
> and disconnected the network cable
> but the slave not change to master

You mean that master is pgpool which has VIP (this is called "active") 
and slave is the other pgpool (this is called "standby"), 
and that you disconnected the LAN cable of the active pgpool,
is this right?

> 
> on pgpool.conf:
> wd_interval = 5
> wd_life_point = 5

Hmm, the standby pgpool should become active in about 30 seconds with 
this parameters.... Maybe, watchdog lifecheck might not have started yet.
Confirm that the following message appears in log messages before
disconneting the cable.

  LOG:    pid 19793:      watchdog: lifecheck started

The tutorial would be helpful for you:
http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html

> 
> well I'm not asking for the watchdog timeout, thought it already existed.
> 
> 
> 
> On Sun, Apr 20, 2014 at 11:49 PM, Yugo Nagata <nagata at sraoss.co.jp> wrote:
> 
> > Hi,
> >
> > On Tue, 15 Apr 2014 16:00:50 -0300
> > Thomaz Luiz Santos <thomaz.santos at gmail.com> wrote:
> >
> > > I wonder if it is possible to configure the watchdog timeout, I've been
> > > doing some testing, and test the server timeout slave was waiting for the
> > > master, the slave is to let take over as master if the master does not
> > > respond for a period of time . ?
> > >
> > > in the pgpool.conf
> > > health_check_timeout = 5
> >
> > health_check_timeout is for timeout of "health check", that is about
> > backend PostgreSQL server.
> >
> > http://www.pgpool.net/docs/pgpool-II-3.2.8/doc/pgpool-en.html#HEALTH_CHECK_TIMEOUT
> >
> > In watchdog of 3.2, pgpool issues a query wd_lifecheck_query ("SELECT 1")
> > to
> > other pgpool every wd_interval seconds, and if this fails wd_life_point
> > times,
> > pgpool regard the other as down.
> > http://www.pgpool.net/docs/pgpool-II-3.2.8/doc/pgpool-en.html#WD_INTERVAL
> >
> > But, parameter to configure timeout for watchdog doesn't exist.
> >
> > Are you requiring this?
> >
> > >
> > > but not work.
> > >
> > > pgpool 3.2.4
> > >
> > > --
> > > ------------------------------
> > > Thomaz Luiz Santos
> > > Linux User: #359356
> > > http://thomaz.santos.googlepages.com/
> >
> >
> > --
> > Yugo Nagata <nagata at sraoss.co.jp>
> >
> 
> 
> 
> -- 
> ------------------------------
> Thomaz Luiz Santos
> Linux User: #359356
> http://thomaz.santos.googlepages.com/


-- 
Yugo Nagata <nagata at sraoss.co.jp>