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

Поиск
Список
Период
Сортировка
От Terje Elde
Тема Re: [BUGS] BUG #14559: Error message of too many clients.
Дата
Msg-id 934A9316-8258-4568-A351-167CB61869A6@elde.net
обсуждение исходный текст
Ответ на [BUGS] BUG #14559: Error message of too many clients.  (sujitm@planittesting.com)
Список 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 по дате отправления:

Предыдущее
От: isayko.alexey@gmail.com
Дата:
Сообщение: [BUGS] BUG #14563: count(*) gives a wrong result in PostgreSQL for someregex with pg_trm/GIN index
Следующее
От: John McKown
Дата:
Сообщение: Re: [BUGS] Error mtk 11009