--okay, but the client has since terminated 
--it's session (if i understand you correctly).

--is this just something that will just have to
--hang around until i shutdown the database / boot
--the machine?

-X

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, September 19, 2002 11:50 AM
To: shridhar_daithankar@persistent.co.in
Cc: 'pgsql-general@postgresql.org'; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] killing process question 


"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> I guess a backend should terminate as if connection is closed. What say? 

No.

It will terminate when it tries to read the next query from the client.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster





RE: [GENERAL] killing process question 


--okay, but the client has since terminated 
--it's session (if i understand you correctly).

--is this just something that will just have to
--hang around until i shutdown the database / boot
--the machine?

-X

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, September 19, 2002 11:50 AM
To: shridhar_daithankar@persistent.co.in
Cc: 'pgsql-general@postgresql.org'; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] killing process question 


"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> I guess a backend should terminate as if connection is closed. What say? 

No.

It will terminate when it tries to read the next query from the client.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Thu, 19 Sep 2002 11:55:18 -0400
"Johnson, Shaunn" <SJohnson6@bcbsm.com>
Re: killing process question 
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> --okay, but the client has since terminated 
> --it's session (if i understand you correctly).
> --is this just something that will just have to
> --hang around until i shutdown the database / boot
> --the machine?

I dunno.  Are you sure this is a backend process?  What is it doing
(or not doing) ... is it chewing any CPU cycles?  What status does it
show in ps?

			regards, tom lane

Thu, 19 Sep 2002 12:07:54 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: killing process question 