Re: [HACKERS] Is there any way to check the status of the Index table.
ocie@paracel.com
From: ocie@paracel.com
To: AliE@atlas.com
Cc: hackers@postgreSQL.org, scrappy@hub.org, 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-11T20:54:26Z
Lists: pgsql-hackers
AliE@atlas.com wrote: > > 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? It also needs to know which executable produced the core file. I usually omit the -c, simply "gcc <executable> <core file>". Hope this helps, Ocie