Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL: Number of waiting connections too high - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: PostgreSQL: Number of waiting connections too high
Date
Msg-id cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com
Whole thread Raw
In response to PostgreSQL: Number of waiting connections too high  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: PostgreSQL: Number of waiting connections too high  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-admin
Tree view

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
Attachment

pgsql-admin by date:

Previous
From: Atul Kumar
Date:
Subject: PostgreSQL: Number of waiting connections too high
Next
From: Atul Kumar
Date:
Subject: Re: PostgreSQL: Number of waiting connections too high