va-tlv-ctm-qa22.isr.bmc.com% sql psql: FATAL: sorry, too many clients already va-tlv-ctm-qa22.isr.bmc.com% sql psql (11.5) Type "help" for help. ctrlmdb=> show max_connections; max_connections ----------------- 1200 (1 row) ctrlmdb=> show shared_buffers; shared_buffers ---------------- 2000MB (1 row) -----Original Message----- From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> Sent: Thursday, April 02, 2020 6:37 PM To: Abraham, Danny <danny_abraham@xxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: [EXTERNAL] Re: too many clients already On 4/2/20 8:35 AM, Abraham, Danny wrote: > Big installation: max_connections is 1200, shared_buffers is 2GB Have you confirmed that the above is actually in effect by doing?: show max_connections; > > -----Original Message----- > From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> > Sent: Thursday, April 02, 2020 6:30 PM > To: Abraham, Danny <danny_abraham@xxxxxxx>; pgsql-general@xxxxxxxxxxxxxx > Subject: [EXTERNAL] Re: too many clients already > > On 4/2/20 8:22 AM, Abraham, Danny wrote: >> No pg-bouncer or connection pooling. >> ps -elf | grep postgres | grep idle | wc -l ==> 61 >> >> and BTW: Running, say 500 one command psql in parallel will have the same affect.. > > Hmm. In psql on the cluster in question what does below return?: > > show max_connections; > >> >> -----Original Message----- >> From: Rob Sargent <robjsargent@xxxxxxxxx> >> Sent: Thursday, April 02, 2020 6:10 PM >> To: Abraham, Danny <danny_abraham@xxxxxxx> >> Cc: pgsql-general@xxxxxxxxxxxxxx >> Subject: [EXTERNAL] Re: too many clients already >> >> >> >>> On Apr 2, 2020, at 9:06 AM, Abraham, Danny <danny_abraham@xxxxxxx> 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)? >> >> > > -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
