Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 42C6A2E0081 for ; Fri, 20 Jun 2008 13:15:20 -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 10155-01 for ; Fri, 20 Jun 2008 13:15:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.int.journyx.com (mail.journyx.com [66.219.41.227]) by developer.postgresql.org (Postfix) with ESMTP id DFA7C2E0054 for ; Fri, 20 Jun 2008 13:15:16 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.int.journyx.com (Postfix) with ESMTP id DF6F43E2177 for ; Fri, 20 Jun 2008 11:15:03 -0500 (CDT) X-Virus-Scanned: amavisd-new at Received: from mail.int.journyx.com ([127.0.0.1]) by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aroVwsr711pf for ; Fri, 20 Jun 2008 11:15:01 -0500 (CDT) Received: from whitneys (dhcp-100-201.int.journyx.com [192.168.100.201]) by mail.int.journyx.com (Postfix) with ESMTP id 2855E3E2165 for ; Fri, 20 Jun 2008 11:15:01 -0500 (CDT) From: "Scott Whitney" To: Subject: Missing chunks from my toast... Date: Fri, 20 Jun 2008 11:18:17 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcjS8T4ovPVqXa+xSTyrArxQMOpEBw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Message-Id: <20080620161501.2855E3E2165@mail.int.journyx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/182 X-Sequence-Number: 29520 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.