Re: killing process question - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: killing process question
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73F7B@snt452.corp.bcbsm.com
Whole thread Raw
In response to killing process question  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Responses Re: killing process question
List pgsql-general

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

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: keeping a log / debug info
Next
From: Tom Lane
Date:
Subject: Re: Memory Errors...