Thread: Kill session in PostgreSQL

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/
> From each according to his ability. To each according to his ability to litigate.

----- 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

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


On Tue, Apr 10, 2007 at 08:46:20AM -0400, Ardian Xharra wrote:
> 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