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

#1

"Adam Kruger" <ackruger (AT) hotmail (DOT) com> writes:

Quote:

I have encountered a condition similar to those referenced at:
http://archives.postgresql.org/pgsql...6/msg00051.php
and
http://archives.postgresql.org/pgsql...6/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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1731: Indexes are corrupt following an unclean shutdown - 06-25-2005 , 06:25 PM