Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7CA4B6330FE for ; Tue, 17 Feb 2009 09:53:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81928-02 for ; Tue, 17 Feb 2009 09:53:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by mail.postgresql.org (Postfix) with ESMTP id 93EC46330F6 for ; Tue, 17 Feb 2009 09:53:36 -0400 (AST) Received: from webmail.zmi.at (websrv1.zmi.at [212.69.162.199]) by mailsrv1.zmi.at (Postfix) with ESMTP id C0110404F for ; Tue, 17 Feb 2009 14:53:34 +0100 (CET) Received: from phpmailer ([81.217.54.243]) by webmail.zmi.at with HTTP (PHPMailer); Tue, 17 Feb 2009 14:53:33 +0100 Date: Tue, 17 Feb 2009 14:53:33 +0100 To: pgsql-admin@postgresql.org From: Michael Monnerie Subject: Re: 8.3.5 broken after power fail Message-ID: <8ce5a7cbfc90bac3f52c2dda013872c4@webmail.zmi.at> X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/116 X-Sequence-Number: 31337 "Michael Monnerie" schrieb: > pg_dump: Fehlermeldung vom Server: ERROR: missing chunk number 0 for=20 > toast value 1460201 in pg_toast_1281127 > pg_dump: Die Anweisung war: COPY public.dbmail_messageblks=20 > (messageblk_idnr, physmessage_id, messageblk, blocksize, is_header) = TO=20 > stdout; The file is there: # ls -l base/16386/1281127 -rw------- 1 postgres postgres 417447936 17. Feb 12:14 base/16386/1281127 What can I do about the missing chunk? I need the data in there... mfg zmi