Re: <IDLE> in transaction - safest way to kill

From: "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org, "William Temperley" <willtemperley(at)gmail(dot)com>
Subject: Re: <IDLE> in transaction - safest way to kill
Date: 2008-12-06 04:03:21
Message-ID: 3f0b79eb0812052003v2a9436a1qfef600333a508b0a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 5, 2008 at 11:25 PM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:
>
> select pg_cancel_backend(<pid>);

No, pg_cancel_backend() cancels only *query*, and doesn't kill idle
in transaction. I think that killing the backend (idle in transaction) with
SIGTERM is better way.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hendra kusuma 2008-12-06 04:11:36
Previous Message Devrim GÜNDÜZ 2008-12-05 17:30:52 Re: Favorite Tom Lane quotes