Re: 0FATAL: too many connections for database

Поиск
Список
Период
Сортировка
От Jim Mlodgenski
Тема Re: 0FATAL: too many connections for database
Дата
Msg-id CAB_5SRc2W0-=w6S52Dz1ijgHS4tK03Y+u6N62qrnc_vobGa31A@mail.gmail.com
обсуждение исходный текст
Ответ на 0FATAL: too many connections for database  ("Pagett, Lacey" <lacey.pagett@hrblock.com>)
Ответы Re: 0FATAL: too many connections for database  ("Pagett, Lacey" <lacey.pagett@hrblock.com>)
Список pgsql-novice



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 по дате отправления:

Предыдущее
От: "Pagett, Lacey"
Дата:
Сообщение: 0FATAL: too many connections for database
Следующее
От: "Pagett, Lacey"
Дата:
Сообщение: Re: 0FATAL: too many connections for database