too many clients already

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: too many clients already
Date: 2020-04-02 15:06:03
Message-ID: c7e50c9443eb4ae8a2eec661c1b000f9@phx-exmbprd-01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2020-04-02 15:09:47 Re: too many clients already
Previous Message Laurenz Albe 2020-04-02 14:57:48 Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12