Re: Corrupted index - Mailing list pgsql-general

From Tom Lane
Subject Re: Corrupted index
Date
Msg-id 4963.1119537374@sss.pgh.pa.us
Whole thread Raw
In response to Corrupted index  (Akash Garg <akash.garg@gmail.com>)
Responses Re: Corrupted index
List pgsql-general
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

pgsql-general by date:

Previous
From: "mrix"
Date:
Subject: fields and foreign keys
Next
From: Michael Fuhr
Date:
Subject: Re: fields and foreign keys