[pgpool-general: 755] Re: Possible bug in the watchdog fucntionality

[Yugo Nagata]

On Tue, 17 Jul 2012 19:14:21 -0430
Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu> wrote:

> I am configured wd_interval = 10 but the wd_lifecheck_query (SELECT 1) seems not be executed in this time. Is this the expected behavior?. Attached is the pgpool.conf, postgresql.log and pgpool.log files.

In pgpool.conf, the listen_addresses value should be '*', because pgpool
accepts connections on both the real IP / hostname (specified by wd_hostname)
and the virtual IP (specified by delegate_IP). 

In your configuration, the listen_addresses value is wrong, so pgpools *cannot* 
monitor each other, and watchdog doesn't start successfully. The query "SELECT 1"
appearing in the log  was sent during preparation of starting alive monitoring.

> 
> Another questions.
> 
> Would be posible to start up pgpool with a user different of root using the watchdog functionality with a combination of sudo command?.

Yes, you can start up pgpool with watchdog functionality by using sudo command.

> 
> Would be possible to start up pgpool with pgpoolAdmin tool when the wathdogfunctionality is running?

Yes, but pgpool must be started with root privilege. There are a few way.
One is to use setuid as follows;
 # chown root bin/pgpool
 # chmod 4755 bin/pgpool

Another way is to set "User" directive in httpd.conf of apache  to "root".
However, it requires to rebulid the apache server.

> 
> Do you know a candidate date for releasing another version of pgpoolAdmin that supports the watchdog functionality?

The next version of pgpoolAdmin will be released in this month.

> 
> Regards.
> 
> ________________________________________
> From: Yugo Nagata [nagata at sraoss.co.jp]
> Sent: Monday, July 16, 2012 10:48 PM
> To: Lazáro Rubén García Martínez
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 743] Watchdog configuration parameters
> 
> > Supose wd_interval = 10 and wd_life_point = 2
> >
> > It means pgpool sends the query "SELECT 1" to another pgpool each 10 seconds and waits for a response in 2 seconds at most. If there is not response in 2 seconds, then the watchdog process is started?
> 
> No.
> 
> In this case, the watchdog process sends the query "SELECT 1" to another pgpool
> every 10 seconds. If there is no response in 2 trials, then the pgpool is
> considered to be DOWN.
> 
> On Mon, 16  Jul 2012 22:35:16 -0430
> Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu> wrote:
> 
> > Hello everyone in the list.
> >
> > I don´t understand very well the explanation about this configurations parameters related with watchdog functionality.
> >
> > wd_interval: This parameter specifies the interval between life checks of pgpool-II in second.
> >
> > wd_life_point: The times to retry a failed life check of pgpool-II.
> >
> > wd_lifecheck_query: Actual query to check pgpool-II. Default is "SELECT 1"
> >
> > Supose wd_interval = 10 and wd_life_point = 2
> >
> > It means pgpool sends the query "SELECT 1" to another pgpool each 10 seconds and waits for a response in 2 seconds at most. If there is not response in 2 seconds, then the watchdog process is started?
> >
> > Regards.
> >
> > 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
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> 
> 
> --
> Yugo Nagata <nagata at sraoss.co.jp>
> SRA OSS, Inc. Japan
> 
> 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


-- 
Yugo Nagata <nagata at sraoss.co.jp>
SRA OSS, Inc. Japan