Re: FATAL: remaining connection slots are reserved for non-replication superuser connections

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