> -----Original Message-----
> From: Magnus Hagander [mailto:mha@sollentuna.net] 
> Sent: Friday, April 02, 2004 2:34 PM
> To: Andrew Dunstan; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Function to kill backend
> 
> 
> >>Hi!
> >>
> >>When debugging on win32, I've created myself a little 
> function that I 
> >>feel should be added to the "backend proper". While it adds 
> a lot of 
> >>vlaue on win32, I think it adds quite a bit of value on non-win32 
> >>platforms as well...
> >>
> >>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 guess it could be. I guess:
> 
> 1) I don't know how to do one of those ;-) Which is why I 
> didn't even think it.
> 
> 2) Won't that clutter up the namespace more, by introducing 
> more keywords that you can't use for other things?
> 
> 3) Will it still be possible to do the kind of things Rod 
> mentioned, e.g. SELECT pg_kill_backend(procpid, 'TERM') FROM 
> pg_stat_activity WHERE current_query LIKE '<IDLE>%'; ?

Sybase had something like that:

Syb_kill <pid> to kill a dangling process.

And the undocumented:

Syb_terminate <pid> 
to absolutely, positively kill it (Syb_kill only worked sometimes).

In general, I think this approach is a bit worrisome.  It reminds one of
the famous tagline:

"Tip: Don't kill -9 the postmaster."


Fri, 2 Apr 2004 14:47:03 -0800
"Dann Corbit" <DCorbit@connx.com>
Re: Function to kill backend