Re: Killing only one postmaster

Поиск
Список
Период
Сортировка
От
Тема Re: Killing only one postmaster
Дата
Msg-id 1135.219.65.236.162.1050085637.squirrel@mail.trade-india.com
обсуждение исходный текст
Ответ на Killing only one postmaster  (stewarrb@yahoo.com (Bo Stewart))
Список pgsql-admin

I think there is only one postmaster and multiple backends.

To cancel the query being executed by a particular backend pid
use

kill -INT <pid_of_the_backend>
its equivalent to pressing ^C in psql for that query.

regds
mallah.

> How do I stop only one postmaster and not have the entire server
> restart?  Is this possible.  I have had several situations where I have a function not
> performing as I expect and need to kill just the backend process.
>
>
> Thanks,
> Bo Stewart
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo@postgresql.org



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/


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

Предыдущее
От: stewarrb@yahoo.com (Bo Stewart)
Дата:
Сообщение: Killing only one postmaster
Следующее
От: Tim Ellis
Дата:
Сообщение: Re: Netscape Suitespot HELP :-/