Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling
Date
Msg-id 2136.1488290839@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Re: GMT FATAL: remaining connection slots are reserved fornon-replication superuser connections, but I'm using pgBouncer forconnection pooling  (Lisandro <rostagnolisandro@gmail.com>)
List pgsql-general
Tree view 
Lisandro <rostagnolisandro@gmail.com> writes:
> Let me ask: is there a way to monitor the total connections to postgresql
> through time? Or should I make my own script for that? I ask because every
> time the error is thrown, I check the total connections with "select
> count(*) from pg_stat_activity;" but the number is always far from the
> configured max_connections.

You could enable log_connections and log_disconnections.

            regards, tom lane

pgsql-general by date:

Previous
From: Lisandro
Date:
Subject: [GENERAL] Re: GMT FATAL: remaining connection slots are reserved fornon-replication superuser connections, but I'm using pgBouncer forconnection pooling
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] Question about TOAST table - PostgreSQL 9.2