From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
Cc: | scrawford(at)pinpointresearch(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: FATAL: remaining connection slots are reserved for non-replication superuser connections |
Date: | 2017-02-08 03:36:26 |
Message-ID: | CAJNY3ivfgBy5V+5po1HZwP7d-+gp2UqV=R-N8XFcbxBq3rZ+gw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2017-02-08 16:27 GMT+13:00 Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2017-02-08 04:37:03 | Re: Logging broken messages |
Previous Message | Tatsuo Ishii | 2017-02-08 03:27:29 | Re: FATAL: remaining connection slots are reserved for non-replication superuser connections |