Postgres Pro
Downloads
Home   >   mailing lists

Re: how to cancel a query ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to cancel a query ?
Date
Msg-id 14847.1039020441@sss.pgh.pa.us
Whole thread Raw
In response to how to cancel a query ?  (Andreas Schmitz <a.schmitz@cityweb.de>)
Responses Re: how to cancel a query ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: how to cancel a query ?  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
Tree view 
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> ist there any way to cancel a user query as dba ?

Send a SIGINT to the backend process running that query, eg

    kill -INT <pid>

This has the same effect as a user-requested cancel (eg ^C in psql).

            regards, tom lane

pgsql-admin by date:

Previous
From: Andreas Schmitz
Date:
Subject: how to cancel a query ?
Next
From: Joel Burton
Date:
Subject: Re: [HACKERS] how to alter sequence.