FATAL: remaining connection slots are reserved for non-replication superuser connections

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: FATAL: remaining connection slots are reserved for non-replication superuser connections
Date: 2017-02-08 02:52:16
Message-ID: CAJNY3ivi9dKFGG0MUZGW=A0159M90kO_a5mrK=6DMao7hyqutQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2017-02-08 03:15:39 Re: FATAL: remaining connection slots are reserved for non-replication superuser connections
Previous Message Tom Lane 2017-02-07 20:12:41 Re: Logging broken messages