Re: stale portmaster processes

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)

In response to

Browse pgsql-general by date

  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???