Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F2209632E5A for ; Tue, 17 Feb 2009 10:12: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 02280-04 for ; Tue, 17 Feb 2009 10:12:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by mail.postgresql.org (Postfix) with ESMTP id 57119632DAF for ; Tue, 17 Feb 2009 10:12:36 -0400 (AST) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id n1HEBDfp059193; Tue, 17 Feb 2009 16:11:13 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id n1HEBCCi059192; Tue, 17 Feb 2009 16:11:12 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: 8.3.5 broken after power fail Date: Tue, 17 Feb 2009 16:11:12 +0200 User-Agent: KMail/1.9.7 Cc: Michael Monnerie References: <8ce5a7cbfc90bac3f52c2dda013872c4@webmail.zmi.at> In-Reply-To: <8ce5a7cbfc90bac3f52c2dda013872c4@webmail.zmi.at> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200902171611.12655.achill@matrix.gatewaynet.com> 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/117 X-Sequence-Number: 31338 =CE=A3=CF=84=CE=B9=CF=82 Tuesday 17 February 2009 15:53:33 =CE=BF/=CE=B7 Mi= chael Monnerie =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > "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; >=20 > The file is there: > # ls -l base/16386/1281127 > -rw------- 1 postgres postgres 417447936 17. Feb 12:14 base/16386/1281127 >=20 did you reindex pg_toast_1281127? take a look at=20 http://archives.free.net.ph/message/20080924.191644.d692f468.el.html > What can I do about the missing chunk? I need the data in there... >=20 > mfg zmi >=20 >=20 >=20 =2D-=20 Achilleas Mantzios