Thread: [BUGS] BUG #14559: Error message of too many clients.

The following bug has been logged on the website:

Bug reference:      14559
Logged by:          Sujit Majhi
Email address:      sujitm@planittesting.com
PostgreSQL version: 9.6.0
Operating system:   Windows
Description:

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.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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