Re: Stale Process

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Terence Leung <tcmleung(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stale Process
Date: 2002-11-10 17:15:09
Message-ID: m3vg35tkgy.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Terence Leung <tcmleung(at)yahoo(dot)com> writes:

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

It's most likely that PHP is keeping the connections open for some
reason. The 'postgres' processes are in S (sleep) state, which
indicates that their socket is still being held open by the client
end. So it's probably not a Postgres problem... I find it entirely
unsurprising that PHP might be buggy. ;)

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-10 17:44:45 Re: SQL syntax (column alias)
Previous Message Vassil Kriakov 2002-11-10 17:10:14 C++: get value for integral types?