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

From Tom Lane
Subject Re: Function to kill backend
Date
Msg-id 8849.1080944881@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function to kill backend  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Function to kill backend  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Magnus Hagander wrote:
>> The function is pg_kill_backend(<pid>,<signal>). superuser-only, of
>> course. Which simply sends a signal to the specified backend -
>> querycancel, terminate, etc.

> If' we're going to have this shouldn't it be a proper command? And maybe 
> an internal shutdown command to go with it?

I don't like the idea at all, but if we were to have something
it would definitely need to be a lot more constrained than
send-any-signal-to-any-postgres-process ... even for a superuser,
that's a mighty fat-gauge foot-gun.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Function to kill backend
Next
From: "Magnus Hagander"
Date:
Subject: Re: Function to kill backend