Re: too many clients already

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: too many clients already
Дата
Msg-id B4363D3A-DFFC-4EDF-BB31-FFBC25DFEE8C@gmail.com
обсуждение исходный текст
Ответ на too many clients already  ("Abraham, Danny" <danny_abraham@bmc.com>)
Ответы RE: Re: too many clients already
Список pgsql-general

> On Apr 2, 2020, at 9:06 AM, Abraham, Danny <danny_abraham@bmc.com> 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)?


В списке pgsql-general по дате отправления:

Предыдущее
От: "Abraham, Danny"
Дата:
Сообщение: too many clients already
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: too many clients already