Re: Bug #807: Sequence currupted on recovery after kill -9

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Bug #807: Sequence currupted on recovery after kill -9
Дата
Msg-id 87iszi73u0.fsf@Login.CERT.Uni-Stuttgart.DE
обсуждение исходный текст
Ответ на Re: Bug #807: Sequence currupted on recovery after kill -9  (Darcy Buskermolen <darcy@wavefire.com>)
Список pgsql-bugs
Darcy Buskermolen <darcy@wavefire.com> writes:

> I'm sure if you read the footers on Tom's email's it's pretty clearly stated
> 'do not kill -9 the postmaster'.
> So I'm not so sure that this is really a bug.

The operating environment is free to kill -9 the postmaster at any
time, and PostgreSQL is expected to ensure database consistency
nevertheless.

After all, PostgreSQL is a database and not a cardbox.

(But holes in sequence numbers certainly do not endanger database
consistency.)

--
Florian Weimer                       Weimer@CERT.Uni-Stuttgart.DE
University of Stuttgart           http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT                          fax +49-711-685-5898

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

Предыдущее
От: Darcy Buskermolen
Дата:
Сообщение: INTERVAL problems with greater than 2^32 seconds
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #809: View not using index