2007/10/24, Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>:
> Hi there,
>
> I read dozens of times the "TIP 2: Don't 'kill -9' the postmaster"...
>
> Now, what am I supposed to do if I launched a query which takes ages, and
> which I want to interrupt?
>
> Thanks for any advice,
>
> Stef
>
Hello
you have to use more gently way
select pg_cancel_backend()
http://www.postgresql.org/docs/current/interactive/functions-admin.html
Pavel
> ____________________________________________________________________
>
>
> Stefan Schwarzer
>
> Lean Back and Relax - Enjoy some Nature Photography:
> http://photoblog.la-famille-schwarzer.de
>
> Appetite for Global Data? UNEP GEO Data Portal:
> http://geodata.grid.unep.ch
>
> ____________________________________________________________________
>
>
>
>
>
