Kill session in PostgreSQL

You can use kill PID
----- Original Message -----
From: Ashish Karalkar
To: pggeneral
Sent: Tuesday, April 10, 2007 8:01 AM
Subject: [GENERAL] Kill session in PostgreSQL

Hello all,
is there any command just like ORACLE Uses kill session to kill a particular session .
tried withh linux kill -9 PID but it also kills all other sessions or am I just giving wrong signal to command kill?

Thanks in advance

With Regards
ashish

------------------------------------------------------------------------------
Check out what you're missing if you're not on Yahoo! Messenger

------------------------------------------------------------------------------

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 09/04/2007 22:59

On Tue, Apr 10, 2007 at 01:01:30PM +0100, Ashish Karalkar wrote:

Hello all,
is there any command just like ORACLE Uses kill session to kill a particular session .
tried withh linux kill -9 PID but it also kills all other sessions or am I just giving wrong signal to command kill?

Uhh, yeah. Kill -9 is bad. The documentation talks about signals but in
general you can use kill -INT to abort a query.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Beware that this is not a supported method, though. It often works, but
don't make it a part of your regular maintenance.

What you can do is use pg_cancel_query() to kick the session back out to
IDLE - that's fully suported, and it will drop any locks the process has,
so it shuold get rid of most of your problem.

//Magnus