Re: Killing a session

kill -15 pid#

will kill a given thread ... you can look in the pg_stat_activity; the query_start shows when it started, the current_query shows at least a portion of the SQL the thread is executing, and procpid if the pid of the process to kill with a -15 command.

Not sure about Windows variants, though.

HTH

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Vitaly Belman [mailto:vitalyb(at)gmail(dot)com]
Sent: Sat 8/21/2004 1:32 PM
To: pgsql-general(at)postgresql(dot)org
Cc:
Subject: [GENERAL] Killing a session
Is there a way to kill a session in PostrgeSQL? I ran a bad query by
mistake and I don't want to shut the whole database just to quit using
the whole CPU.

--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)