Skip site navigation (1) Skip section navigation (2)

Re: Killing a session

From: Vitaly Belman <vitalyb(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Killing a session
Date: 2004-08-22 03:16:30
Message-ID: fa96e3c604082120169dd1e8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Even better. Thanks =).

On Sat, 21 Aug 2004 20:14:53 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 
> 
> Vitaly Belman <vitalyb(at)gmail(dot)com> writes:
> > 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.
> 
> ISTM what you really want is query cancel, not whole-session kill.
> Try "kill -INT <pid-of-backend>".
> 
>                         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 
> 


-- 
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent(at)hotmail(dot)com
 Yahoo!: VitalyBe

In response to

pgsql-general by date

Next:From: sripathy senaDate: 2004-08-22 04:28:05
Subject: PLPGSQL Install Help
Previous:From: Bruce MomjianDate: 2004-08-22 03:02:05
Subject: Re: Few questions on postgresql (dblink, 2pc, clustering)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group