Re: Missing chunks from my toast...

"Scott Whitney" <swhitney(at)journyx(dot)com> writes:
> 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.

You forgot the attachments, but did you reindex the table itself, or its
toast table? The former cannot fix this, the latter might possibly.

Easiest way to get the toast table name is
select reltoastrelid::regclass from pg_class where relname = 'mytable';
(if you've got more than one table with the same name, obviously you
need to add a condition on schema as well). You'll probably need to be
superuser to reindex it.

regards, tom lane