Re: killing a hung postgres process brings down the Postgres database server on MAC OS X!

Поиск
Список
Период
Сортировка
От Rosser Schwarz
Тема Re: killing a hung postgres process brings down the Postgres database server on MAC OS X!
Дата
Msg-id 37d451f7040927163636c9f64c@mail.gmail.com
обсуждение исходный текст
Ответ на killing a hung postgres process brings down the Postgres database server on MAC OS X!  (Qing Zhao <qzhao@supplyfx.com>)
Список pgsql-admin
while you weren't looking, Qing Zhao wrote:

[...]

> Is there a way to kill the dead processes/thread without really affect
> the PG server?

See: http://www.postgresql.org/docs/7.3/static/postmaster-shutdown.html

I have occasionally had to kill -9 a backend, but it's never been
pleasant.  Avoid if at all possible.

/rls

--
:wq

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: moving pg_xlog
Следующее
От: Tom Lane
Дата:
Сообщение: Re: killing a hung postgres process brings down the Postgres database server on MAC OS X!