Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovering database after disk crash - Mailing list pgsql-general

From Tom Lane
Subject Re: Recovering database after disk crash
Date
Msg-id 29077.1210634163@sss.pgh.pa.us
Whole thread Raw
In response to Recovering database after disk crash  ("Vic Simkus" <vic.simkus@gmail.com>)
Responses Re: Recovering database after disk crash  ("Vic Simkus" <vic.simkus@gmail.com>)
List pgsql-general
Tree view 
"Vic Simkus" <vic.simkus@gmail.com> writes:
> 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

If you're really lucky, doing the reindex with ignore_system_indexes
enabled will go through.  Otherwise, it's time to go back to your
last backups :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Andy Anderson
Date:
Subject: Re: rounding problems
Next
From: Shane Ambler
Date:
Subject: Re: changing the endianness of a database