Am in the process of salvaging very crucial data from a corrupted database.
Am getting the following error from a very crucial table
ERROR: invalid page header in block 94206 of relation base/11974232/11975439
set zero_damaged_pages to on , I realized I end up losing alot of pages which contain data that's significant to a meaningful recovery.
so my question is:-
1.How do I maximize data recovery without loosing the pages?
- when I do a query on some tables, the connection gets lost before the query executes. usually the query runs for few seconds before the disconnection. How do I deal with this