Hi All,
In one of my postgres databases multiple tables got corrupted and followed the below steps but still the same error.
1.SET zero_damaged_pages = on
2. VACUUM ANALYZE, VACUUM FULL
but still same error.
moh_fa=# VACUUM FULL;
ERROR: could not read block 9350 in file "base/1156523/1270812": Input/output error
ERROR: could not read block 9350 in file "base/1156523/1270812": Input/output error
Tried to take backup of tables with pg_dump but same error. files exist physically in base location.
How to proceed on this, no backup to restore.
Thanks in advance
Regards,
Vasu Madhineni
