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