0FATAL: too many connections for database

From: "Pagett, Lacey" <lacey(dot)pagett(at)hrblock(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: 0FATAL: too many connections for database
Date: 2014-01-06 23:35:08
Message-ID: 9E6C96FBDE336C419E308685558BAB3F4962A438FE@BCMSG03.hrbinc.hrblock.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

We are currently seeing "FATAL: too many connections for database error" in the $PG_DATA/pg_log.
However, pg_stat_activity shows 50 connections with max_connections set to 800 in postgresql.conf and the role connection limit in pg_roles for all users is unlimited (-1).

Any ideas what could cause the error when connections seem to be available?

Thanks for any suggestions!

Lacey

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Mlodgenski 2014-01-06 23:45:13 Re: 0FATAL: too many connections for database
Previous Message Sergey Konoplev 2014-01-06 20:53:33 Re: Master-slave failover question