Re: PostgreSQL: Number of waiting connections too high

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL: Number of waiting connections too high
Date: 2020-12-15 09:21:21
Message-ID: cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Atul Kumar 2020-12-15 09:33:12 Re: PostgreSQL: Number of waiting connections too high
Previous Message Atul Kumar 2020-12-15 09:15:57 PostgreSQL: Number of waiting connections too high