Re: PostgreSQL: Number of waiting connections too high

[Wim Bertels <wim.bertels@xxxxxxx>]

Atul Kumar schreef op di 15-12-2020 om 15:03 [+0530]:

Hi,

The max_connections are 5000.

but I am getting the alert on mere 500 connections.

have a look a connection pooling Atul

or

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

Please suggest why is this happening.

Regards,

Atul

On 12/15/20, Holger Jakobs <holger@xxxxxxxxxx> 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"