Skip site navigation (1) Skip section navigation (2)

Re: Canceling/Killing a query

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Vitaly Belman" <vitalyb(at)gmail(dot)com>,"PostgreSQL Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Canceling/Killing a query
Date: 2004-12-12 13:59:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32
You can use "pg_ctl kill" on the commandline, or you can use the
function pg_cancel_backend(), see


>-----Original Message-----
>From: pgsql-hackers-win32-owner(at)postgresql(dot)org 
>[mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of 
>Vitaly Belman
>Sent: den 12 december 2004 14:40
>To: PostgreSQL Win32
>Subject: [pgsql-hackers-win32] Canceling/Killing a query
>Is there a way to kill a query that was ran from PHP?
>In Linux you could kill the process, but what can I do in windows?
>Restarting the service is hardly the best option.
> ICQ: 1912453
> AIM: VitalyB1984
> MSN: tmdagent(at)hotmail(dot)com
> Yahoo!: VitalyBe
>---------------------------(end of 
>TIP 8: explain analyze is your friend

pgsql-hackers-win32 by date

Next:From: Ian BarwickDate: 2004-12-12 17:14:27
Subject: initdb / Unicode
Previous:From: Vitaly BelmanDate: 2004-12-12 13:40:23
Subject: Canceling/Killing a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group