[GENERAL] FATAL: remaining connection slots are reserved for non-replicationsuperuser connections

Поиск
Список
Период
Сортировка
От Patrick B
Тема [GENERAL] FATAL: remaining connection slots are reserved for non-replicationsuperuser connections
Дата
Msg-id CAJNY3ivi9dKFGG0MUZGW=A0159M90kO_a5mrK=6DMao7hyqutQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Дерево обсуждения
Hi guys,

I get these messages at least once a day in my Prod environment: 
FATAL:  remaining connection slots are reserved for non-replication superuser connections

I do not have a DB pooler and my max_connections is 200. However, max connections for my PHP Application is 120.

My server has 128GB and SSD 10K iops disks (Amazon EBS).


Can you guys please outlines me the steps to troubleshoot this?

Interesting is that I didn't see any IO/CPU limitation on my server.

I'm currently running a Postgres 9.2 - one master and one slave streaming replication.


Thanks

Patrick

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Logging broken messages
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections