Re: BUG #14559: Error message of too many clients.

> On 21 Feb 2017, at 07:50, sujitm(at)planittesting(dot)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, pooler or similar.

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

Terje