Re: How to Cancel a query ?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to Cancel a query ?
Date: 2004-03-02 16:48:04
Message-ID: 20040302164804.GB10799@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 01, 2004 at 03:48:00PM -0800, Kuldeep Tanna wrote:
> How do I cancel the execution of that query. I tried restarting /
> stopping postmaster, but pg_ctl gives an error message "Unable to
> shutdown server"

Find the pid of the backend doing the work (you can use psto find it)
and then issue kill -2 <pid>

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-03-02 17:02:47 Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions)
Previous Message Ron St-Pierre 2004-03-02 16:08:49 Re: Setting up Postgresql on Linux