Stale Process - Mailing list pgsql-general

From Terence Leung
Subject Stale Process
Date
Msg-id 20021110164717.90877.qmail@web40702.mail.yahoo.com
Whole thread Raw
Responses Re: Stale Process  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
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?





=====
Yours sincerely,
    Leung Chun Man, Terence

    Mobile: (852) 9273 9176
    Homepage:  http://tcmleung.uhome.net ,
    http://www.dynamicdrive.com/dynamicindex4/filter/index.htm

__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

pgsql-general by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: [JDBC] [HACKERS] PostgreSQL JDBC and sub-select
Next
From: Vassil Kriakov
Date:
Subject: C++: get value for integral types?