[pgpool-general: 2714] Re: existing connections did not close in 0 sec

Tatsuo Ishii ishii at postgresql.org
Mon Apr 7 21:47:09 JST 2014


> Yes, of course you are correct. However in the pgpool.conf file itself
> it just says "Timeout in seconds to wait for the recovering node's
> postmaster to start up" which is what misled me.

Good point. Can you please propose better wording?

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

> In case I haven't said it before, thanks for the great software!

Thanks for using pgpool-II!

> Regards,
> Sean
> 
> On 14-04-05 07:27 AM, Tatsuo Ishii wrote:
>> I think it's documented:
>>
>> recovery_timeout
>>      pgpool does not accept new connections during the second stage. If
>>      a client connects to pgpool during recovery processing, it will
>>      have to wait for the end of the recovery.
>>
>>      This parameter specifies recovery timeout in sec. If this timeout
>>      is reached, pgpool cancels online recovery and accepts
>>      connections. 0 means no wait.
>>
>>      This parameter can be changed without restarting.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> Sorry, this was my error... the recovery_timeout on that server had
>>> been 'temporarily' set to 0. Mind you, the documentation doesn't say
>>> recovery_timeout is used to control the wait for existing connections
>>> to close. Nevertheless it was my mistake.
>>>
>>> Thanks,
>>> Sean
> 


More information about the pgpool-general mailing list