Re: hung back end - Mailing list pgsql-general

From Richard Huxton
Subject Re: hung back end
Date
Msg-id 004101c09294$fb715ea0$1001a8c0@archonet.com
Whole thread Raw
In response to hung back end  ("Thomas T. Thai" <tom@minnesota.com>)
List pgsql-general
----- Original Message -----
From: "Thomas T. Thai" <tom@minnesota.com>


> i'm porting some apps from mysql to pgsql and i'm using php4.0.5-cvs with
> phplib db classes. i'm starting to see that when ever i load a web page,
> it starts a backend. then when i try to reload the page, i get:
>
> sure i could increase the # of child processes, but instead i decided to
> check why it was doing this. it appears that after a webpage is openned, a
> new child process or backend starts. the persistent link doesn't seem to
> exist any longer. on the next reload, a new process. but the old one never
> disappeared. it'll sit there for hours and days.

IIRC there is a known problem with PHP's cached db connections to postgres.
Basically, as you've seen it doesn't reuse old backends, so you run out of
connections. See the archive for details. I think someone is looking at this
on the PHP side.

- Richard Huxton


pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Checking Permissions with SQL
Next
From: Guillaume Lémery
Date:
Subject: CopyObject Error 635