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?