Re: Corrupted index

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