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_queryshows at least a portion of the SQL the thread is executing, and procpid if the pid of the process to kill
witha -15 command. 

Not sure about Windows variants, though.

HTH

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:    Vitaly Belman [mailto:vitalyb@gmail.com]
Sent:    Sat 8/21/2004 1:32 PM
To:    pgsql-general@postgresql.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@hotmail.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@postgresql.org)