Re: 0FATAL: too many connections for database

Jim,

You're amazing. I think that is it - THANK YOU!!!

From: Jim Mlodgenski [mailto:jimmy76(at)gmail(dot)com]
Sent: Monday, January 06, 2014 5:45 PM
To: Pagett, Lacey
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] 0FATAL: too many connections for database

On Mon, Jan 6, 2014 at 6:35 PM, Pagett, Lacey <lacey(dot)pagett(at)hrblock(dot)com<mailto:lacey(dot)pagett(at)hrblock(dot)com>> wrote:
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?

Is there a limit set on the database? You would be able to see it by selecting from pg_database.

Thanks for any suggestions!

Lacey