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:[EMAIL PROTECTED] Sent: Sat 8/21/2004 1:32 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Yahoo!: VitalyBe ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org