Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 7EB182E0081 for ; Fri, 20 Jun 2008 13:41:12 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32490-04 for ; Fri, 20 Jun 2008 13:41:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 90DC72E0054 for ; Fri, 20 Jun 2008 13:41:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m5KGetOB020569; Fri, 20 Jun 2008 12:40:55 -0400 (EDT) To: "Scott Whitney" cc: pgsql-admin@postgresql.org Subject: Re: Missing chunks from my toast... In-reply-to: <20080620161501.2855E3E2165@mail.int.journyx.com> References: <20080620161501.2855E3E2165@mail.int.journyx.com> Comments: In-reply-to "Scott Whitney" message dated "Fri, 20 Jun 2008 11:18:17 -0500" Date: Fri, 20 Jun 2008 12:40:55 -0400 Message-ID: <20568.1213980055@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/183 X-Sequence-Number: 29521 "Scott Whitney" 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