"Lukasz Piskorz" <[EMAIL PROTECTED]> writes: > When I check all tables only one (very important in my database) is > corrupted: > database=>select * from table; > ERROR: cannot read block 7959 of pg_log: Success
This looks like something is trying to access the commit status of an out-of-range transaction number, which is usually the first failure you get when a row header has been corrupted. (In more recent PG versions, you'd get a complaint about trying to access a nonexistent pg_clog file.) The odds are that the corruption has damaged an entire page of that table. I'm afraid there's no question that you've lost some data. You might be able to partially recover by zeroing out the broken page --- that would at least let you dump the data in the remaining pages of the table. See the mail list archives concerning methods for locating data corruption more precisely. > Could you help me? What can I do? Can I remove this table and restore from > backup? If you have a recent backup that might be the way to go. > What do you think about software > http://svana.org/kleptog/pgsql/pgfsck.html ? I dunno if that works on versions as old as 7.0. One thing you should definitely do as soon as you've extracted as much data as you can is to update to some newer version. 7.0.* was a long time and a lot of bug fixes ago. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
