If I'm understanding the errors correctly it seems that the corruption is in the system catalogs (metadata). The database does not use any fancy datatypes. Is there any way for me to rebuild the metadata manually? If I can see the leftover metadata and the data minus the missing metadata I can probably piece everything together enough to get the data out. Does that make sense or am I off my rocker? On 5/12/08, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Vic Simkus" <vic.simkus@xxxxxxxxx> 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 > -- Men never do evil so completely and cheerfully as when they do it from religious conviction. -Blaise Pascal
