[pgpool-general: 7960] Re: Antwort: Re: Re: Pgpool does not accept new connections (Tatsuo Ishii)
martin.quevedo at temiandu.com
martin.quevedo at temiandu.com
Thu Dec 23 23:03:15 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
-----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