Re: [ADMIN] ERROR: could not read block

2011-05-22 Thread Diego Fernández Slezak
Thanks Tom. I executed a REINDEX DATABASE and received the error: . . . NOTICE: table pg_enum was reindexed NOTICE: table pg_namespace was reindexed NOTICE: table pg_conversion was reindexed NOTICE: table pg_depend was reindexed NOTICE: table users was reindexed NOTICE: table results was

[ADMIN] ERROR: could not read block

2011-05-21 Thread Diego Fernández Slezak
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