Re: too many clients already

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: too many clients already
Date: 2020-04-02 15:09:47
Message-ID: B4363D3A-DFFC-4EDF-BB31-FFBC25DFEE8C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Apr 2, 2020, at 9:06 AM, Abraham, Danny <danny_abraham(at)bmc(dot)com> wrote:
>
> Hi,
>
> Will appreciate a hint here.
>
> Running on a big and stressed AIX platform and receiving lots of "CDTFATAL: sorry, too many clients already"
> and transient difficulty to log in.
>
> Happens on all PG versions (Tested 9.5,10.4,11.5)
>
> Big installation: max_connections is 1200, shared_buffers is 2GB
>
> But .. select count(*) from pg_stat_activity is only 66.
>
> Thanks
>
> Danny
>
>
Lots of idle, kept-alive clients? Do you have a connection pooler (e.g. pg-bouncer)?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-04-02 15:20:38 Re: too many clients already
Previous Message Abraham, Danny 2020-04-02 15:06:03 too many clients already