Re: Stale Process - Mailing list pgsql-general

From Doug McNaught
Subject Re: Stale Process
Date
Msg-id m3vg35tkgy.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Stale Process  (Terence Leung <tcmleung@yahoo.com>)
Responses Re: Stale Process
List pgsql-general
Terence Leung <tcmleung@yahoo.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

pgsql-general by date:

Previous
From: Vassil Kriakov
Date:
Subject: C++: get value for integral types?
Next
From: "Aurangzeb M. Agha"
Date:
Subject: Upgrading from 7.1.3 to 7.2.3