ERROR: could not read block

From: Diego Fernández Slezak <dfslezak(at)dc(dot)uba(dot)ar>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: could not read block
Date: 2011-05-21 12:39:46
Message-ID: BANLkTinK8-Gz01ARiAryB0Hx+oJac=D=HA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 would like to know if there is any way to say to postgres to drop all rows
that corresponds to that file. In that way I would save most of my data.

Thanks in advance
Diego

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Diego Fernández Slezak 2011-05-21 12:41:26 ERROR: could not read block
Previous Message teguh 2011-05-21 10:48:31 Re: LDAP Authentication