Re: Function to kill backend

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Function to kill backend
Date: 2004-04-03 00:19:14
Message-ID: 406E0302.3060309@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-04-03 00:35:20 Re: Problems Vacuum'ing
Previous Message Jim Seymour 2004-04-03 00:08:54 Re: Problems Vacuum'ing