Fixing up a corrupted toast table

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Fixing up a corrupted toast table
Дата
Msg-id 78A9FFF6-F468-46DD-BBEC-443A7268DB01@blighty.com
обсуждение исходный текст
Ответы Re: Fixing up a corrupted toast table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have an older 7.4 installation which is giving this error
during pg_dump:

pg_dump: ERROR:  missing chunk number 0 for toast value 25923965
pg_dump: SQL command to dump the contents of table "element"
failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR:  missing chunk number 0 for
toast value 25923965

(slightly edited, but not in any significant way).

I believe that it's a known issue that occasionally causes this (this
is not a bug report, and I'm quite aware of point upgrades and so on)
and the server will likely be updated to 8.1.current within the month.

I'd like to make the current problem go away, though, perhaps by
deleting the relevant row in the element table. I'm not quite sure how
to go about that, though. Could anyone point me in the right direction?

Cheers,
   Steve


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

Предыдущее
От: "Justin B. Kay"
Дата:
Сообщение: return setof and Temp tables
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Fwd: [pgsql-jp: 36715] Josh Berkus氏の講演MP3