Missing chunks from my toast...

Поиск
Список
Период
Сортировка
От Scott Whitney
Тема Missing chunks from my toast...
Дата
Msg-id 20080620161501.2855E3E2165@mail.int.journyx.com
обсуждение исходный текст
Ответы Re: Missing chunks from my toast...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
There goes my breakfast...

pg_dump: ERROR:  missing chunk number 0 for toast value 110439697
pg_dump: SQL command to dump the contents of table "attachments" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast
value 110439697
pg_dump: The command was: COPY public.attachments (id, transactionid,
parent, messageid, subject, filename, contenttype, contentencoding, content,
headers, creator, created) TO stdout;


I've tried reindexing this table (attachments), to no avail. Is there any
way I can fix this db. This is not on a mission-critical machine, but it is
a business-critical db. I can take it up and down as necessary.


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

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: where would I find the files I need?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing chunks from my toast...