Re: stale portmaster processes - Mailing list pgsql-general

From Thomas T. Thai
Subject Re: stale portmaster processes
Date
Msg-id Pine.NEB.4.21.0101142045090.1583-100000@ns01.minnesota.com
Whole thread Raw
In response to Re: stale portmaster processes  (Peter Eisentraut <peter_e@gmx.net>)
List 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)


pgsql-general by date:

Previous
From: Ben Stringer
Date:
Subject: Re: Creating a database
Next
From: Chris Ian Capon Fiel
Date:
Subject: Re: VB and PostgreSQL