[pgpool-general: 7965] Re: Antwort: Re: Re: Pgpool does not accept new connections (Tatsuo Ishii)

Tatsuo Ishii ishii at sraoss.co.jp
Mon Dec 27 20:23:43 JST 2021


> Here is my situation
> I have a software that opens 5 connections to pgpool
> Every night I restart this software, so it opens another 5 connections and
> sometimes the older connections are not dropped
> It can happen also that connectios are idle for a few hours, before I
> restart my software, that is during the day
> If a channel is dropped because it was idle during the day my software is
> not able to re open it. 
> So, in order to make sure I don't close an idle channel during the day
> (because of the idle parameter in pgpool) I need to use several hours, like
> 5 hours or something

Ok, I think setting client_idle_limit to a few hours makes sense then.

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

> -----Original Message-----
> From: Tatsuo Ishii <ishii at sraoss.co.jp> 
> Sent: Thursday, December 23, 2021 2:40 AM
> To: martin.quevedo at temiandu.com
> Cc: ehansmair at prompt-software.de; pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 7943] Re: Antwort: Re: Re: Pgpool does not
> accept new connections (Tatsuo Ishii)
> 
>> Is it ok to specify a few hours of idle time ?
> 
> But then new connections will not be accepted for a few hours when all
> pgpool process are occupied by idle clients. I am not sure whether it's ok
> for you.
> 
>> -----Original Message-----
>> From: Tatsuo Ishii <ishii at sraoss.co.jp>
>> Sent: Tuesday, December 21, 2021 8:06 PM
>> To: martin.quevedo at temiandu.com
>> Cc: ehansmair at prompt-software.de; pgpool-general at pgpool.net
>> Subject: Re: [pgpool-general: 7943] Re: Antwort: Re: Re: Pgpool does 
>> not accept new connections (Tatsuo Ishii)
>> 
>>> Hello Tatsuo,
>>> 
>>> About this event ' Pgpool does not accept new connections'
>>> 
>>> Would it be possible to allow pgpool to automatically select a new 
>>> child that has been idle for a configurable amount of time?
>> 
>> No. But you can use client_idle_limit. If a child process is idle for 
>> specified amount time, it will automatically exit and a new child is 
>> forked to accept new connections.
>> 
>> Best reagards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> 
>> 
>>> Regards,
>>> Martin
>>> 
>>> 
>>> 
>>> -----Original Message-----
>>> From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of 
>>> Tatsuo Ishii
>>> Sent: Friday, December 17, 2021 8:54 PM
>>> To: ehansmair at prompt-software.de
>>> Cc: pgpool-general at pgpool.net
>>> Subject: [pgpool-general: 7943] Re: Antwort: Re: Re: Pgpool does not 
>>> accept new connections (Tatsuo Ishii)
>>> 
>>>> Hello,
>>>> 
>>>> I am sorry, we are using Pgpool 4.2.5. The pcp_proc_info of that 
>>>> Version does not show the process status.
>>> 
>>> Ok. You can use standard ps command to know the process status.
>>> 
>>>   23669 pts/3    S      0:00 pgpool: wait for connection request
>>> 
>>> If you see some pgpool process in "wait for connection request" 
>>> state, then it means pgpool have room to accept connections from clients.
>>> 
>>> Best reagards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>> 
>> 
> 


More information about the pgpool-general mailing list