On Wed, Feb 07, 2007 at 03:00:20AM -0700, Ed L. wrote: > How do I fix this 7.4.6 issue short of initdb? > > invalid page header in block 110 of relation "pg_statistic"
Take a copy of the file, then you should be able to truncate it. There's also the zero_damaged_pages option, though I don't know whether that applies here. > I looked at the block via pg_filedump (included below), and it > does not appear to me to be corrupted, so not sure what I would > zero out, if anything. I don't see anything odd expect that the header has both a lot of items and a lot of free space... > Items: 35 Free Space: 8032 > Length (including item array): 164 Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
