Re: PostgreSQL: Number of waiting connections too high

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