Akash Garg <akash.garg@xxxxxxxxx> 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
