Re: (Never?) Kill Postmaster? - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: (Never?) Kill Postmaster?
Date
Msg-id 1193206550.8040.25.camel@neuromancer.home.net
Whole thread Raw
In response to (Never?) Kill Postmaster?  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
Responses Re: (Never?) Kill Postmaster?  (Christian Schröder <cs@deriva.de>)
List pgsql-general
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')

>

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: (Never?) Kill Postmaster?
Next
From: "Pavel Stehule"
Date:
Subject: Re: function result cache for pl/pgsql