From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: stale portmaster processes |
Date: | 2001-01-15 02:46:20 |
Message-ID: | Pine.NEB.4.21.0101142045090.1583-100000@ns01.minnesota.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, 14 Jan 2001, Peter Eisentraut wrote:
> Thomas T. Thai writes:
>
> > i've noticed that when using php scripts or the "c" cgi search.cgi from
> > mnogosearch, if i access either script from the web browser and stop it
> > with ESC in the middle of it trying to access the pgsql db, the associated
> > postmaster process hangs around forever and won't disappear:
> >
> > 19276 p1 I 0:00.11 postmaster: web mnwork [local] idle (postgres)
> > 19920 p1 I 0:00.08 postmaster: web mnwork [local] idle (postgres)
> > 19958 p1 I 0:00.10 postmaster: web mnwork [local] idle (postgres)
>
> These look like backend processes left around as part of the persistent
> connection thing that PHP does. On the next connection they will get
> reused, or so is the theory.
most of the time they didn't get reused. some were from a C based cgi
program too. i tried leaving them there for days and they never
disappeared (no further access from php scripts or cgi)
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Crockett | 2001-01-15 03:54:51 | Backend doesn't like this query... |
Previous Message | Brett W. McCoy | 2001-01-15 02:31:07 | Re: Can't compare decimal columns??? |