Hello
A disk hosting an instance of 8.2 crashed on me (hardware failure). I
was able to pull most of the data off the drive, but the one database
that I need the most is corrupt. I'm not really sure where to
start... so here are some error messages:
postgres@vsimkus-laptop:/var/log/postgresql$ pg_dump EPC
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: index
"pg_opclass_am_name_nsp_index" contains unexpected zero page at block
0
HINT: Please REINDEX it.
pg_dump: The command was: SELECT tableoid, oid, *, (SELECT rolname
FROM pg_catalog.pg_roles WHERE oid = '10') as lanowner FROM
pg_language WHERE lanispl ORDER BY oid
postgres@vsimkus-laptop:/var/log/postgresql$ reindexdb EPC
NOTICE: table "pg_class" was reindexed
reindexdb: reindexing of database "EPC" failed: ERROR: catalog is
missing 4 attribute(s) for relid 10762
Almost every operation I attempt ends in a similar error message:
EPC=# \dt
ERROR: index "pg_opclass_am_name_nsp_index" contains unexpected zero
page at block 0
HINT: Please REINDEX it.
EPC=# select * from siemr_sys.zip_codes;
ERROR: catalog is missing 10 attribute(s) for relid 1337158
EPC=# select * from siemr_sys.sex_list;
ERROR: catalog is missing 2 attribute(s) for relid 1337150
EPC=# select * from siemr_data.visits;
ERROR: catalog is missing 7 attribute(s) for relid 1337095
Is there some way I can extract the data from the tables even if the
metadata is corrupt?
Thanks
Vic
--
Men never do evil so completely and cheerfully as when they do it from
religious conviction.
-Blaise Pascal