Re: Stale Process

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.)