HI Loganathan, There is corruption specific to a toasted column index . Do NOT allow the application to connect to the database. Application will most likely make the corruption worse if it starts writing to the database
Do a pg_dump if that fails. then start doing pg_dumps one table at a time to extract what you can. SELECT * FROM xxxx PosgreSQL will just read the table out without using indexes. If you get toast table corruption, SELECT <all columns that are not toasted> FROM XXXX If you get table corruption that is to specific data pages then you need to figure out WHERE clauses to avoid the corrupt datapage. Can use a page inspector to look at the raw table data to maybe get the corrupted datapages back or skip the corrupted pages . https://www.postgresql.org/docs/current/pageinspect.html >
