Akash Garg <akash.garg@gmail.com> writes:
> During a vacuum, I ran into this error:
> vacuumdb: vacuuming of database "friend" failed: ERROR: invalid page
> header in block 41661 of relation "friend_pkey"
> I've read the posts on this newsgroup and it's clear that I have to
> REINDEX to fix this. The bigger question is -- why did this happen in
> the first place?
Good question. If you haven't REINDEXed yet, it would be worthwhile
to get a hex dump (use "od -x") of that page of the index first.
Speculation with no data to look at is a bit pointless ...
regards, tom lane