Re: How to terminate a query

On Tue, Apr 20, 2010 at 2:42 PM, A B <gentosaker@gmail.com> wrote:
> Hi there!
>
> select * from pg_stat_activity;
> shows me a
>  select my_function(....)
> query that has been running for too long.
> How do I kill it?

select pg_cancel_backend(pid);
will kill a running query.

> kill -9 of the procpid seems  to kill the entire server process. So

kill -9 is NOT recommended.

Sometimes cancel_backend fails because there's no point where the code
checks for a cancel.