[pgpool-general: 2458] Re: pgpool out of node problem

[Tatsuo Ishii]

> Hello,
> 
> I have problem, my node is periodically dropped out of pool. Every morning
> same time.
>>From log, I can see that pgpool loses connection to node.
> 
> I know that my server provider have feature to disable connection because
> of inactivity. For example if I have ssh connection to my server for long
> time, without activity, I lost connection.
> 
> My short question is, is it possible that this feature affect my pgpool
> configuration, and how?

Try:
fail_over_on_backend_error = off
connection_life_time = 30

"fail_over_on_backend_error = off" prevents pgpool from doing failover
when your server disconnects.

"connection_life_time = 30" disconnects idle connection from pgpool to
your server and the disconnecting from your severside will be ignored.

"30" may be needed to be adjusted to match your provider's idle
connection watch time.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp