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:
pg_dump: Error message from server: ERROR: missing chunk number 0 for toast
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
|Next:||From: Tom Lane||Date: 2008-06-20 16:40:55|
|Subject: Re: Missing chunks from my toast... |
|Previous:||From: Geoffrey||Date: 2008-06-20 15:56:45|
|Subject: Re: where would I find the files I need?|