Re: Recovering database after disk crash

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Vic Simkus" <vic(dot)simkus(at)gmail(dot)com> writes:
> > postgres(at)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