ERROR: could not read block

From: Diego Fernández Slezak <dfslezak(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: could not read block
Date: 2011-05-21 12:41:26
Message-ID: BANLkTinMSGGm+6+tgKVZMHXJbO3ZoE_9LQ@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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wolfgang Keller 2011-05-21 13:19:12 Re: visualizing database schema - png/jpeg?
Previous Message Diego Fernández Slezak 2011-05-21 12:39:46 ERROR: could not read block