pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL: Number of waiting connections too high
5+ messages / 4 participants
[nested] [flat]
* PostgreSQL: Number of waiting connections too high
@ 2020-12-15 09:15 Atul Kumar <akumar14871@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Atul Kumar @ 2020-12-15 09:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL: Number of waiting connections too high
@ 2020-12-15 09:21 Holger Jakobs <holger@jakobs.com>
parent: Atul Kumar <akumar14871@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Holger Jakobs @ 2020-12-15 09:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL: Number of waiting connections too high
@ 2020-12-15 09:33 Atul Kumar <akumar14871@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Atul Kumar @ 2020-12-15 09:33 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi,
The max_connections are 5000.
but I am getting the alert on mere 500 connections.
Please suggest why is this happening.
Regards,
Atul
On 12/15/20, Holger Jakobs <holger@jakobs.com> 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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL: Number of waiting connections too high
@ 2020-12-15 09:48 Wim Bertels <wim.bertels@ucll.be>
parent: Atul Kumar <akumar14871@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Wim Bertels @ 2020-12-15 09:48 UTC (permalink / raw)
To: Atul Kumar <akumar14871@gmail.com>; Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
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 Atulor
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serverhttps://wiki.postgresql.org/wiki/Repli...
> Please suggest why is this happening.
>
>
>
> Regards,
> Atul
>
>
>
>
> On 12/15/20, Holger Jakobs <holger@jakobs.com> 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"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL: Number of waiting connections too high
@ 2020-12-15 14:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: Atul Kumar <akumar14871@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2020-12-15 14:37 UTC (permalink / raw)
To: Atul Kumar <akumar14871@gmail.com>; +Cc: pgsql-admin
Atul Kumar <akumar14871@gmail.com> writes:
> I am getting below error of
> PostgreSQL: Number of waiting connections too high.
Hmm ... the other responses presumed that what you are running into
is ERRCODE_TOO_MANY_CONNECTIONS (53300), but I'm not entirely
convinced, because the standard wording of the message for that
is "sorry, too many clients already". I think you have some
client-side issue. Alternatively, maybe you are already using
a connection pooler and this message is coming from that.
In that case, you need to reconfigure the pooler to allow
more clients.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-12-15 14:37 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-15 09:15 PostgreSQL: Number of waiting connections too high Atul Kumar <akumar14871@gmail.com>
2020-12-15 09:21 ` Holger Jakobs <holger@jakobs.com>
2020-12-15 09:33 ` Atul Kumar <akumar14871@gmail.com>
2020-12-15 09:48 ` Wim Bertels <wim.bertels@ucll.be>
2020-12-15 14:37 ` Tom Lane <tgl@sss.pgh.pa.us>
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