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

From Tatsuo Ishii
Subject Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Date
Msg-id 20170208.122729.247071103029362236.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Patrick B <patrickbakerbr@gmail.com>)
List 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 by date:

Previous
From: Steve Crawford
Date:
Subject: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Next
From: Patrick B
Date:
Subject: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections