From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL: Number of waiting connections too high
Date: Tue, 15 Dec 2020 10:21:21 +0100
Message-ID: <cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com> (raw)
In-Reply-To: <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
References: <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL: Number of waiting connections too high
In-Reply-To: <cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox