Stale Process

From: Terence Leung <tcmleung(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Stale Process
Date: 2002-11-10 16:47:17
Message-ID: 20021110164717.90877.qmail@web40702.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vassil Kriakov 2002-11-10 17:04:42 C++: get value for integral types?
Previous Message Joe Conway 2002-11-10 16:38:37 Re: SQL syntax (column alias)