Обсуждение: 0FATAL: too many connections for database
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
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
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