Re: Cancelling long running query?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Cancelling long running query?
Date: 2002-11-11 19:58:49
Message-ID: 200211111158.49538.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Patrick,

> How can I cancel a long running query besides quitting the app?
> TIA

Methods:
1) Shutdown and restart the database server with pg_ctl -m fast restart.
2) Kill the client connection proccess on the server side. This is dangerous
if the long-running query is a data-modification query.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-11-12 00:58:23 Re: Cancelling long running query?
Previous Message Patrick Hatcher 2002-11-11 19:51:14 Cancelling long running query?