On Mon, Oct 23, 2017 at 7:44 AM, Peter Hunčár <hunci(at)hunci(dot)sk> wrote:
> I know that zero_damaged_pages and vacuum (or restore the table from backup)
> will help, but I want to ask if there is a way to identify affected
> rows/datafiles, so we can 'fix' only the affected data using the
> backup/source data, instead of restoring the whole table?
You might find the latest version of amcheck helpful here:
https://github.com/petergeoghegan/amcheck
It's not really written with repair in mind, since that's such a can
of worms, but it might still help you.
--
Peter Geoghegan