Re: [GENERAL] (Never?) Kill Postmaster?

From: Ow Mun Heng <Ow.Mun.Heng(at)wdc.com>
Date: Wed Oct 24 2007 - 02:15:50 EDT

On Wed, 2007-10-24 at 07:57 +0200, Stefan Schwarzer wrote:
> Hi there,
>
>
> I read dozens of times the "TIP 2: Don't 'kill -9' the postmaster"...
>
>
> Now, what am I supposed to do if I launched a query which takes ages,
> and which I want to interrupt?

look for the query's procpid and then issue a select pg_cancel_backend('the_id')

>

---------------------------(end of broadcast)---------------------------

TIP 5: don't forget to increase your free space map settings Received on Wed Oct 24 02:21:17 2007