0FATAL: too many connections for database

Поиск
Список
Период
Сортировка
От Pagett, Lacey
Тема 0FATAL: too many connections for database
Дата
Msg-id 9E6C96FBDE336C419E308685558BAB3F4962A438FE@BCMSG03.hrbinc.hrblock.net
обсуждение исходный текст
Ответы Re: 0FATAL: too many connections for database  (Jim Mlodgenski <jimmy76@gmail.com>)
Список pgsql-novice

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

 

 

 

 

 

В списке pgsql-novice по дате отправления:

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Master-slave failover question
Следующее
От: Jim Mlodgenski
Дата:
Сообщение: Re: 0FATAL: too many connections for database