| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sripathy sena | 2004-08-22 04:28:05 | PLPGSQL Install Help |
| Previous Message | Bruce Momjian | 2004-08-22 03:02:05 | Re: Few questions on postgresql (dblink, 2pc, clustering) |