Re: 0FATAL: too many connections for database

From: Jim Mlodgenski <jimmy76(at)gmail(dot)com>
To: "Pagett, Lacey" <lacey(dot)pagett(at)hrblock(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: 0FATAL: too many connections for database
Date: 2014-01-06 23:45:13
Message-ID: CAB_5SRc2W0-=w6S52Dz1ijgHS4tK03Y+u6N62qrnc_vobGa31A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pagett, Lacey 2014-01-06 23:48:44 Re: 0FATAL: too many connections for database
Previous Message Pagett, Lacey 2014-01-06 23:35:08 0FATAL: too many connections for database