Thread: 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@hotmail.com Yahoo!: VitalyBe
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@postgresql.org >[mailto:pgsql-hackers-win32-owner@postgresql.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@hotmail.com > Yahoo!: VitalyBe > >---------------------------(end of >broadcast)--------------------------- >TIP 8: explain analyze is your friend >