Re: [BUGS] BUG #14559: Error message of too many clients. - Mailing list pgsql-bugs

From Terje Elde
Subject Re: [BUGS] BUG #14559: Error message of too many clients.
Date
Msg-id 934A9316-8258-4568-A351-167CB61869A6@elde.net
Whole thread Raw
In response to [BUGS] BUG #14559: Error message of too many clients.  (sujitm@planittesting.com)
List pgsql-bugs
> On 21 Feb 2017, at 07:50, sujitm@planittesting.com wrote:
>
> We have connected postgres to Dynatrace 6.3 While connecting the dynatrace
> performance warehouse error is shown as Fatal:Too many clients already
> connected even the number of actual connected clients is very minimum. The
> maximum limit set for connection of clients is 200.

You can check out which active sessions you have, if you:

SELECT * FROM pg_stat_activity;

Most likely this is due to the number of connections, so it would need to be fixed somewhere else, in the clients,
pooleror similar. 

You might also want to look into pgbouncer, which can pool connections for you.

Terje



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: isayko.alexey@gmail.com
Date:
Subject: [BUGS] BUG #14563: count(*) gives a wrong result in PostgreSQL for someregex with pg_trm/GIN index
Next
From: John McKown
Date:
Subject: Re: [BUGS] Error mtk 11009