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
In response to
pgsql-general by date
|Next:||From: Jim Worke||Date: 2004-08-22 02:34:00|
|Subject: Few questions on postgresql (dblink, 2pc, clustering)|
|Previous:||From: Gregory S. Williamson||Date: 2004-08-21 20:45:24|
|Subject: Re: Killing a session|