From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Stefan Schwarzer" <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: (Never?) Kill Postmaster? |
Date: | 2007-10-24 06:09:54 |
Message-ID: | 162867790710232309u792b59d8wcf1f742d51d85141@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2007/10/24, Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)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
>
> ____________________________________________________________________
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ow Mun Heng | 2007-10-24 06:15:50 | Re: (Never?) Kill Postmaster? |
Previous Message | Vyacheslav Kalinin | 2007-10-24 06:06:08 | Re: (Never?) Kill Postmaster? |