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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
