Re: Corrupted index

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Akash Garg <akash(dot)garg(at)gmail(dot)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
>