Re: Corrupt Table
Bryan White <bryan@arcamax.com>
From: "Bryan White" <bryan@arcamax.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "pgsql-general" <pgsql-general@postgreSQL.org>
Date: 2000-09-15T14:11:35Z
Lists: pgsql-general
> > My guess is the internal structure of one of the tuples is corrupt. > > So it would seem. Evidently there's at least one more corrupted page > besides the ones you were able to identify before. I punted last night and reloaded the customer table from a backup. Turns out I could recreate the most critical records from other sources. Life goes on. I would still like to refine my pganal tool to look inside of tuples. Where should I look to find information about the internal structure? Is it parsable at some level on its own or do I have to consult the system tables to determine stucture. I suspect this might get more complicated once TOAST is available. Bryan White