Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Дата
Msg-id 20170208.122729.247071103029362236.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
> Something is using too many connections.
>
> I may be wrong but I'm unaware of a limit on connections from PHP except
> when you are using persistent connections. Since each PHP script is it's
> own process, it can create one or more connections. I'd check to be sure
> that every PHP script you have is, indeed, using pg_pconnect and not
> pg_connect. That missing "p" could be hard to spot. I'm assuming, of
> course, that you are sure that your PHP script are the only things that can
> connect - no scripts, backups, etc. are consuming connections.

You can disable persistent connection feature of pg_pconnect by
tweaking php.ini.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Следующее
От: Patrick B
Дата:
Сообщение: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections