On Mon, Oct 23, 2017 at 7:44 AM, Peter Hunčár <hunci@xxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
