Re: Cleanly cancel a query. - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject Re: Cleanly cancel a query.
Date
Msg-id Pine.LNX.4.21.0106081703290.17741-100000@aluminum.cs.pitt.edu
Whole thread Raw
In response to Cleanly cancel a query.  (Dennis <dennis@zserve.com>)
Responses Re: Cleanly cancel a query.  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List 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
>


pgsql-general by date:

Previous
From: Somazx Interesting
Date:
Subject: Re: Can not pg_dumpall
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Cleanly cancel a query.