Re: How to Cancel a query ?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: How to Cancel a query ?
Дата
Msg-id 20040302164804.GB10799@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на How to Cancel a query ?  ("Kuldeep Tanna" <kuldeep@cse.ogi.edu>)
Список pgsql-general
On Mon, Mar 01, 2004 at 03:48:00PM -0800, Kuldeep Tanna wrote:
> How do I cancel the execution of that query. I tried restarting /
> stopping postmaster, but pg_ctl gives an error message "Unable to
> shutdown server"

Find the pid of the backend doing the work (you can use psto find it)
and then issue kill -2 <pid>

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron St-Pierre
Дата:
Сообщение: Re: Setting up Postgresql on Linux
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Database metadata queries (WAS Re: Moving from MySQL to PGSQL....some questions)