Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] table corruption - Mailing list pgsql-general

From Peter Hunčár
Subject [GENERAL] table corruption
Date
Msg-id CADOjABnKXR1g20Pb14dbH50hyeYPQqYo+MGisQYWnj_ot_JtOg@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] table corruption  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general
Tree view
Hi,

we have a table with around 1.6 billion rows having quite lot of big binary data toasted.

Today we started getting:
WIB > ERROR:  invalid page in block 1288868309 of relation base/96031/96201

Which is a toast reltype.

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?

Thank you

Regards

P.


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: [GENERAL] multiple sql results to shell
Next
From: Michael Nolan
Date:
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare