Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Date
Msg-id 27903.1119487230@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1726: Whenever i reboot my tables indexes is getting corrupted.  ("Prasad Duggineni" <pduggineni@prominencenet.com>)
List pgsql-bugs
Tree view 
"Prasad Duggineni" <pduggineni@prominencenet.com> writes:
> It is throwing=20
> the following ERROR "error index "clusters_pkey" is not a btree"
> I have to reindex the tables every time whenever i reboot.

Could we have a look at the contents of the first page of the index
file when this is happening?  Plain old "od -x" will do for making
the dump.  See contrib/oid2name if you need help figuring out which
file is the troublesome index.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Prasad Duggineni"
Date:
Subject: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Next
From: "Charlie Monkton"
Date:
Subject: BUG #1725: psql --command and PQexec do not work and fail silently