Re: Function to kill backend - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Function to kill backend
Date
Msg-id 24749.1081264129@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function to kill backend  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: Function to kill backend  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
"Magnus Hagander" <mha@sollentuna.net> writes:
>> If we are going to allow session kill then of course we need 
>> PID for that.

> I still say we need this.

Well, that seems to be the consensus, so I won't stand in the way.

If you like the cancel-by-XID idea then I'd suggest providing two
functions: pg_cancel_query(XID) to send SIGINT and pg_kill_session(PID)
to send SIGTERM.  I'm not sure if the other two combinations (SIGINT by
PID and SIGTERM by XID) are worth providing.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Function to kill backend
Next
From: Bruce Momjian
Date:
Subject: Re: Function to kill backend