Re: Cleanly cancel a query.

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Dennis <dennis(at)zserve(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cleanly cancel a query.
Date: 2001-06-08 21:04:07
Message-ID: Pine.LNX.4.21.0106081703290.17741-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can kill -TERM the postmaster that is executing the particular query.

cheers,
t.

On Fri, 8 Jun 2001, Dennis wrote:

> If I have a database running, and I see that
> there is a postmaster process taking 99.9% cpu.
>
> ie, a very large insert query.
>
> Is there a way to cleanly shut down that query from the client or admin
> side?
>
>
> -Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Somazx Interesting 2001-06-08 21:06:57 Re: Can not pg_dumpall
Previous Message Stacy Cornbread 2001-06-08 20:59:25 Re: Accessing two differents database in a SELECT