Thread: PostgreSQL: Number of waiting connections too high

HI,

I have postgres with 11.8 version.

I am getting below error of
PostgreSQL: Number of waiting connections too high.

Please help me in solving this situation.



Regards,
Atul

Hi,

TCP maintains a backlog of waiting connections if a server application doesn't accept or deny connections.

PostgreSQL has a setting max_connections, so it won't accept any more.

So there are two solutions:

• Lower the number of concurrent clients
• Increase the max_connections setting in postgresql.conf

Regards,

Holger

HI,

I have postgres with 11.8 version.

I am getting below error of
PostgreSQL: Number of waiting connections too high.

Please help me in solving this situation.



Regards,
Atul

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Hi,

The max_connections are 5000.

but I am getting the alert on mere 500 connections.

Please suggest why is this happening.



Regards,
Atul




On 12/15/20, Holger Jakobs <holger@jakobs.com> wrote:
> Hi,
>
> TCP maintains a backlog of waiting connections if a server application
> doesn't accept or deny connections.
>
> PostgreSQL has a setting max_connections, so it won't accept any more.
>
> So there are two solutions:
>
>   * Lower the number of concurrent clients
>   * Increase the max_connections setting in postgresql.conf
>
> Regards,
>
> Holger
>
> Am 15.12.20 um 10:15 schrieb Atul Kumar:
>> HI,
>>
>> I have postgres with 11.8 version.
>>
>> I am getting below error of
>> PostgreSQL: Number of waiting connections too high.
>>
>> Please help me in solving this situation.
>>
>>
>>
>> Regards,
>> Atul
>>
>>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>

Hi,

The max_connections are 5000.

but I am getting the alert on mere 500 connections.

Please suggest why is this happening.

Regards,

Atul

On 12/15/20, Holger Jakobs <holger@jakobs.com> wrote:

Hi,

TCP maintains a backlog of waiting connections if a server application

doesn't accept or deny connections.

PostgreSQL has a setting max_connections, so it won't accept any more.

So there are two solutions:

  * Lower the number of concurrent clients

  * Increase the max_connections setting in postgresql.conf

Regards,

Holger

Am 15.12.20 um 10:15 schrieb Atul Kumar:

HI,

I have postgres with 11.8 version.

I am getting below error of

PostgreSQL: Number of waiting connections too high.

Please help me in solving this situation.

Regards,

Atul

--

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

-- 
mvg,
Wim Bertels
--
https://coronalert.be

Lector
UC Leuven-Limburg
--
Consider well the proportions of things.  It is better to be a young June-bug
than an old bird of paradise.		-- Mark Twain, "Pudd'nhead Wilson's Calendar"

Atul Kumar <akumar14871@gmail.com> writes:
> I am getting below error of
> PostgreSQL: Number of waiting connections too high.

Hmm ... the other responses presumed that what you are running into
is ERRCODE_TOO_MANY_CONNECTIONS (53300), but I'm not entirely
convinced, because the standard wording of the message for that
is "sorry, too many clients already".  I think you have some
client-side issue.  Alternatively, maybe you are already using
a connection pooler and this message is coming from that.
In that case, you need to reconfigure the pooler to allow
more clients.

            regards, tom lane