[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