Mauri, I'm no expert but I can tell you what I know. We
have experienced this same problem, and I asked a
similar question not too long ago.
- This is probably due to some sort of I/O problem. In
our case, it occurs very frequently on reboots, and
it appears to be related to dirty buffers not being
flushed out when the partition is unmounted. Look
into a newer kernel, and/or newer/different
filesystem (we have seen this in various flavors
of the 2.4.6 kernel with XFS, JFS and EXT3).
- If you have invalid page headers, you should take a
look at the run-time parameter zero_damaged_pages.
You can use this to fix up a table (losing the data
on the bad pages).
- We have not found a way around the missing log file
problem. This appears to end up locking some rows
Others on this list may be able to tell you about tools
for examining/fixing corrupt tables and log files.
In response to
pgsql-admin by date
|Next:||From: akanksha kulkarni||Date: 2005-04-28 17:38:11|
|Previous:||From: Mauri Sahlberg||Date: 2005-04-28 06:27:30|
|Subject: Help desperately needed: reoccurring invalid page header|