=?ISO-8859-1?Q?Diego_Fern=E1ndez_Slezak?= <dfsle...@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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin