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

From Andrew Dunstan
Subject Re: Function to kill backend
Date
Msg-id 406E0302.3060309@dunslane.net
Whole thread Raw
In response to Re: Function to kill backend  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Function to kill backend  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:

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


What sort of constraints do you have in mind?

cheers

andrew



pgsql-hackers by date:

Previous
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Problems Vacuum'ing
Next
From: Tom Lane
Date:
Subject: Re: Problems Vacuum'ing