Re: ERROR: could not read block - Mailing list pgsql-admin

From Tom Lane
Subject Re: ERROR: could not read block
Date
Msg-id 1278.1305990969@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: could not read block  (Diego Fernández Slezak <dfslezak@gmail.com>)
Responses Re: ERROR: could not read block
List pgsql-admin
=?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= <dfslezak@gmail.com> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Who is causing all this i/o?
Next
From: Syed Khan
Date:
Subject: shutdown procedure warm standby