Akash Garg <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to