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

From Patrick B
Subject Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Date
Msg-id CAJNY3ivfgBy5V+5po1HZwP7d-+gp2UqV=R-N8XFcbxBq3rZ+gw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-general
2017-02-08 16:27 GMT+13:00 Tatsuo Ishii <ishii@sraoss.co.jp>:
> 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.


@Steven, yes, my developer said we are using persistent connections.

However, he checked and he is using pg_connect instead of pg_pconnect.

Patrick 

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] FATAL: remaining connection slots are reserved fornon-replication superuser connections
Next
From: John DeSoi
Date:
Subject: Re: [GENERAL] Logging broken messages