Tom, I'll try running the od command -- I'm just a little confused on where I run it. I tried running od -x 41661 but that doesn't yield any results. I'm assuming I have to run this command on the actual index file itself -- how do I do this?
Thanks, Akash On 6/23/05, Tom Lane <[EMAIL PROTECTED]> wrote: > 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 4: Don't 'kill -9' the postmaster
