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

[martin.quevedo at temiandu.com]

Is it ok to specify a few hours of idle time ?

-----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
>