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@sss.pgh.pa.us> wrote:
> 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
>