Postgres Pro
Downloads
Home   >   mailing lists

Re: 0FATAL: too many connections for database - Mailing list pgsql-novice

From Pagett, Lacey
Subject Re: 0FATAL: too many connections for database
Date
Msg-id 9E6C96FBDE336C419E308685558BAB3F4962A43923@BCMSG03.hrbinc.hrblock.net
Whole thread Raw
In response to Re: 0FATAL: too many connections for database  (Jim Mlodgenski <jimmy76@gmail.com>)
List pgsql-novice
Tree view

Jim,

 

You’re amazing.  I think that is it – THANK YOU!!!

 

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

 

 

 

On Mon, Jan 6, 2014 at 6:35 PM, Pagett, Lacey <lacey.pagett@hrblock.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

 

 

 

 

 

 

pgsql-novice by date:

Previous
From: Jim Mlodgenski
Date:
Subject: Re: 0FATAL: too many connections for database
Next
From: "Simon ..."
Date:
Subject: Testing if a Column Exists in a NEW record of a Trigger Function