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: | 6BCB9D8A16AC4241919521715F4D8BCE476362@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
You can use "pg_ctl kill" on the commandline, or you can use the
function pg_cancel_backend(), see
http://developer.postgresql.org/docs/postgres/functions-admin.html#FUNCT
IONS-ADMIN-SIGNAL-TABLE
//Magnus
>-----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
>broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2004-12-12 17:14:27 | initdb / Unicode |
Previous Message | Vitaly Belman | 2004-12-12 13:40:23 | Canceling/Killing a query |