Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Prasad Duggineni" <pduggineni(at)prominencenet(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Date: 2005-06-23 00:40:30
Message-ID: 27903.1119487230@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Prasad Duggineni" <pduggineni(at)prominencenet(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-06-23 15:13:11 Re: BUG #1725: psql --command and PQexec do not work and fail silently
Previous Message Prasad Duggineni 2005-06-22 22:47:53 BUG #1726: Whenever i reboot my tables indexes is getting corrupted.