how to cancel a query in progress

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how to cancel a query in progress
Date: 2009-06-17 13:38:01
Message-ID: 8ec76080906170638u79cbd2b5m3e4ff06c42ef1669@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had a few queries that were fired from pgAdmin, but failed to stop
running after I killed the GUI.

I tried to stop the queries by killing the pid (of the process running
the query, not the pid of the server) from the linux command line, and
much to my surprise, the whole database went down and then recovered
(using the data in pg_xlog I assume).

So, now that I've learned this lesson, what is the proper way to kill
a query, and can it be done from psql or are there special postgres
tools to do this.

Thanks,
Whit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-06-17 14:42:16 Re: Naming functions with reserved words
Previous Message Aaron 2009-06-17 12:27:16 GiST or GIN, I feel like I am doing something wrong