Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id DCB02B5D801 for ; Sat, 21 May 2011 12:16:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 01131-04 for ; Sat, 21 May 2011 15:16:12 +0000 (UTC) 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 mail.postgresql.org (Postfix) with ESMTP id C353EB5DC00 for ; Sat, 21 May 2011 12:16:11 -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 p4LFG9FD001279; Sat, 21 May 2011 11:16:09 -0400 (EDT) To: =?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= cc: pgsql-admin Subject: Re: ERROR: could not read block In-reply-to: References: Comments: In-reply-to =?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= message dated "Sat, 21 May 2011 09:41:26 -0300" Date: Sat, 21 May 2011 11:16:09 -0400 Message-ID: <1278.1305990969@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/143 X-Sequence-Number: 37580 =?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= writes: > Hello everybody, > I had a hard drive failure last week. After lots of effort I've been able to > backup a 700GB database, with only one file with corruption. > When I do some big queries, it throws me errors on this faulty file: > could not read block 390041 of relation 1663/350994/351212: read only 0 of > 8192 bytes I'm guessing this is the result of an index entry pointing to a block that's not there --- either the index is corrupted, or you lost some data. In any case, reindexing the table ought to get rid of this error. regards, tom lane