Re: Killing a session

Even better. Thanks =).

On Sat, 21 Aug 2004 20:14:53 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
> Vitaly Belman <vitalyb@gmail.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@hotmail.com
 Yahoo!: VitalyBe