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
