Is there any way to check the status of the Index table.

alie@atlas.com

From: AliE@atlas.com
To: hackers@postgreSQL.org, scrappy@hub.org
Cc: DeeL@atlas.com, BobbS@atlas.com, Hari_Harikumar@prepaid.atlas.com, Thoi_Sieu-hoa@atlas.com, JephK@atlas.com, David_Schanen@atlas.com
Date: 1998-05-11T15:39:44Z
Lists: pgsql-hackers
We installed the 6.3.2 on our system and now the nature of our data
corruption has changed. It used to give us "BTP_CHAIN errors " message
but now it is doing a core dump. I have two questions.

1. Is there a way to check the status of the Index files to see if they
are OK and not corrupted? Since I did not know of anyway to test the
index files, We tried to start the system without reindexing and it
failed, yet after rendering, it works fine for almost a day. The
corruption happens almost after the pick hour everyday.
2. Do you know of a good way to read the Core Dump file? We have FreeBsd
Unix and I have tried to read the file with "gdb -c coredumpfile.core"
command, but it complains about the format of the file. Any clue?