Talk About Network

Google




Play Stock Market Games
Fantasy Stock Picking Contest

Data Bases > Pgsql General > Recovering data...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 15514 of 16301
Post > Topic >>

Recovering database after disk crash

by vic.simkus@[EMAIL PROTECTED] ("Vic Simkus") May 12, 2008 at 03:38 PM

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@[EMAIL PROTECTED]
 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@[EMAIL PROTECTED]
 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.***_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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 6 Posts in Topic:
Recovering database after disk crash
vic.simkus@[EMAIL PROTECT  2008-05-12 15:38:38 
Re: Recovering database after disk crash
vic.simkus@[EMAIL PROTECT  2008-05-12 16:18:30 
Re: Recovering database after disk crash
tgl@[EMAIL PROTECTED] (T  2008-05-12 19:16:03 
Re: Recovering database after disk crash
vic.simkus@[EMAIL PROTECT  2008-05-12 19:17:22 
Re: Recovering database after disk crash
tgl@[EMAIL PROTECTED] (T  2008-05-12 20:27:59 
Re: Recovering database after disk crash
vic.simkus@[EMAIL PROTECT  2008-05-12 20:00:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Aug 8 12:58:52 CDT 2008.