| From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | scrawford(at)pinpointresearch(dot)com |
| Cc: | patrickbakerbr(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FATAL: remaining connection slots are reserved for non-replication superuser connections |
| Date: | 2017-02-08 03:27:29 |
| Message-ID: | 20170208.122729.247071103029362236.t-ishii@sraoss.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick B | 2017-02-08 03:36:26 | Re: FATAL: remaining connection slots are reserved for non-replication superuser connections |
| Previous Message | Steve Crawford | 2017-02-08 03:15:39 | Re: FATAL: remaining connection slots are reserved for non-replication superuser connections |