Postgres Pro
Downloads
Home   >   mailing lists

Re: Killing a session - Mailing list pgsql-general

From Tom Lane
Subject Re: Killing a session
Date
Msg-id 25507.1093133693@sss.pgh.pa.us
Whole thread Raw
In response to Killing a session  (Vitaly Belman <vitalyb@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Killing a session
Next
From: Jim Worke
Date:
Subject: Few questions on postgresql (dblink, 2pc, clustering)