Re: Stale Process

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Terence Leung <tcmleung(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stale Process
Date: 2002-11-11 17:00:37
Message-ID: Pine.LNX.4.33.0211110959220.22944-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 10 Nov 2002, Terence Leung wrote:

> Dear sir,
> I built Apache, PHP-PostgreSql 7.1 web server in Linux
> Redhat 7.0.
> I always check the process by 'ps -aux' and always
> found the stale postmaster processes:
>
> postgres 9212 0.0 2.1 6136 2408 ? S
> Nov09 0:02 postgres: nobody newmy3qdb [local] idle
> postgres 10617 0.0 2.4 5628 2740 ? S
> Nov09 0:02 postgres: nobody newmy3qdb [local] idle
>
> The processes would not disappear if I don't kill the
> processess.
> I only use 'pg_connect' but never use
> 'pg_pconnect'(permanent connection), so why does it
> happen and how to solve the problem so that the stale
> process can automatically disappear?

As a followup to my previous message, the other possibility is that you
have a PHP page that is segfaulting halfway through, and the connection is
being left hanging since the process died before it could close it.

But the other two possibilities are more still more likely (i.e. psql
is running, or you have a pg_pconnect somewhere you haven't found yet.)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-11 17:14:53 Re: question about efficiency
Previous Message Jean-Luc Lachance 2002-11-11 16:26:15 Re: Win2K Questions