Missing chunks from my toast... - Mailing list pgsql-admin

From Scott Whitney
Subject Missing chunks from my toast...
Date
Msg-id 20080620161501.2855E3E2165@mail.int.journyx.com
Whole thread Raw
Responses Re: Missing chunks from my toast...  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Geoffrey
Date:
Subject: Re: where would I find the files I need?
Next
From: Tom Lane
Date:
Subject: Re: Missing chunks from my toast...