What happens when you kill the postmaster?

Поиск
Список
Период
Сортировка
От Ralf Schuchardt
Тема What happens when you kill the postmaster?
Дата
Msg-id 9940E5D1-C32D-4D36-9BBC-ADCCCD84A529@gmx.de
обсуждение исходный текст
Ответы Re: What happens when you kill the postmaster?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Список pgsql-general
Hi,

on one of our Mac servers an update (Remote Desktop Client) killed yesterday the postmaster process. Apparently this
didnot have any influence on existing connections and therefore was not detected until some time later, when no
connectionfor a backup could be made. 

I have then closed all apps with connections to the database. This brought the whole cluster down. It restarted then
withsome transaction log rollback messages and seems to be running fine since then. 

Can I now expect that the database is in a consistent state, or must I assume the database is corrupted?
I could run a dump-all without problems and there are rows created after the death the postmaster.

Thanks.

Ralf Schuchardt

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

Предыдущее
От: Maximilian Tyrtania
Дата:
Сообщение: Re: Collate order on Mac OS X, text with diacritics in UTF-8
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Extremely Slow Cascade Delete Operation