Re: Corrupt Table

Поиск
Список
Период
Сортировка
От Bryan White
Тема Re: Corrupt Table
Дата
Msg-id 001f01c01f1e$dbb00600$2dd260d1@arcamax.com
обсуждение исходный текст
Ответ на Corrupt Table  ("Bryan White" <bryan@arcamax.com>)
Ответы Re: Corrupt Table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "chris markiewicz"
Дата:
Сообщение: RE: what is the equivalent of oracle's DESCRIBE table?
Следующее
От: "Adam Lang"
Дата:
Сообщение: Re: what is the equivalent of oracle's DESCRIBE table?