Re: BUG #1731: Indexes are corrupt following an unclean shutdown

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1731: Indexes are corrupt following an unclean shutdown
Дата
Msg-id 3215.1119741810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1731: Indexes are corrupt following an unclean shutdown  ("Adam Kruger" <ackruger@hotmail.com>)
Список pgsql-bugs
"Adam Kruger" <ackruger@hotmail.com> writes:
> I have encountered a condition similar to those referenced at:
> http://archives.postgresql.org/pgsql-admin/2005-06/msg00051.php
> and
> http://archives.postgresql.org/pgsql-bugs/2005-06/msg00142.php
> I have come up with a simple method for reproducing this error condition.

Thanks for the test case.  The solution (at least for the near future)
seems to be to force a checkpoint during CREATE DATABASE.  Until 8.0.4
is out, you can protect yourself against this problem by doing a
CHECKPOINT command manually after CREATE DATABASE.

I'm not certain that this explains the other reports, although it well
may.  The second complainant in particular didn't mention anything
about the problem being in a recently-created database.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: can't startup PG-8.0.3
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: BUG #1727: Corrupt Zip file?