Re: postgres process got stuck in "notify interrupt waiting" status

Поиск
Список
Период
Сортировка
От Aleksey Tsalolikhin
Тема Re: postgres process got stuck in "notify interrupt waiting" status
Дата
Msg-id CA+jMWoePaBLqZcyNVCyFSs_rcAeH+AM7+hOog0_-UyQ4Wf9HKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres process got stuck in "notify interrupt waiting" status  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: postgres process got stuck in "notify interrupt waiting" status  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-general
On Wed, Sep 5, 2012 at 7:38 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Having said that, a kill -9 on an individual backend (*not* the
> postmaster) should be safe enough, if you don't mind the fact that
> it'll kill all your other sessions too.
>

Got it, thanks.

Why will it kill all your other sessions too?  Isn't there a separate backend
process for each session?

Best,
-at


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgres process got stuck in "notify interrupt waiting" status
Следующее
От: Johan Nel
Дата:
Сообщение: Re: alter view, add/drop column