Re: pg_terminate_backend for same-role

Поиск
Список
Период
Сортировка
От Daniel Farina
Тема Re: pg_terminate_backend for same-role
Дата
Msg-id CAAZKuFZ1_6p_zE2esf12-jkT++TZFiauDkCs7448EtrxMVrGuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_terminate_backend for same-role  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: pg_terminate_backend for same-role
Список pgsql-hackers
On Thu, Mar 15, 2012 at 9:39 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Fri, Mar 16, 2012 at 8:14 AM, Daniel Farina <daniel@heroku.com> wrote:
>> Parallel to pg_cancel_backend, it'd be nice to allow the user to just
>> outright kill a backend that they own (politely, with a SIGTERM),
>> aborting any transactions in progress, including the idle transaction,
>> and closing the socket.
>
> +1

Here's a patch implementing the simple version, with no more guards
against signal racing than have been seen previously.  The more
elaborate variants to close those races is being discussed in a
parallel thread, but I thought I'd get this simple version out there.

--
fdr

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Дмитрий
Дата:
Сообщение: Postgres 8.4 planner question - bad plan, good plan for almost same queries.
Следующее
От: Daniel Farina
Дата:
Сообщение: Re: Cross-backend signals and administration (Was: Re: pg_terminate_backend for same-role)