Subject: Re: PostgreSQL: Number of waiting connections too high
To: pgsql-admin@lists.postgresql.org
References: 
 <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com>
Date: Tue, 15 Dec 2020 10:21:21 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.5.0
MIME-Version: 1.0
In-Reply-To: 
 <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="7eWbk67HXlY3OQZGlL8rl9QIoIgxiQ7dV"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--7eWbk67HXlY3OQZGlL8rl9QIoIgxiQ7dV
Content-Type: multipart/mixed; boundary="PgitLy6C9wa5wpOv51o7gNt1rDdKkJKJz";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com>
Subject: Re: PostgreSQL: Number of waiting connections too high
References: <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
In-Reply-To: <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>

--PgitLy6C9wa5wpOv51o7gNt1rDdKkJKJz
Content-Type: multipart/alternative;
 boundary="------------3CDC9E06D23F414269DA4F32"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------3CDC9E06D23F414269DA4F32
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi,

TCP maintains a backlog of waiting connections if a server application=20
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
>
>
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------3CDC9E06D23F414269DA4F32
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>Hi,</p>
    <p>TCP maintains a backlog of waiting connections if a server
      application doesn't accept or deny connections.</p>
    <p>PostgreSQL has a setting max_connections, so it won't accept any
      more. <br>
    </p>
    <p>So there are two solutions:</p>
    <ul>
      <li>Lower the number of concurrent clients</li>
      <li>Increase the max_connections setting in postgresql.conf</li>
    </ul>
    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <div class=3D"moz-cite-prefix">Am 15.12.20 um 10:15 schrieb Atul
      Kumar:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=3DZ9_RxEaHvg@mail.gm=
ail.com">
      <pre class=3D"moz-quote-pre" wrap=3D"">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


</pre>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------3CDC9E06D23F414269DA4F32--

--PgitLy6C9wa5wpOv51o7gNt1rDdKkJKJz--

--7eWbk67HXlY3OQZGlL8rl9QIoIgxiQ7dV
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCX9iAEQUDAAAAAAAKCRCKV5yTsxlhuund
AKDCXr1/1y4WsMzHPfMAG8CcSAT94wCgtjXkycl8q08TBvF4Y1jigHq4AME=
=tyDA
-----END PGP SIGNATURE-----

--7eWbk67HXlY3OQZGlL8rl9QIoIgxiQ7dV--