Re: Recovering database after disk crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vic Simkus" <vic(dot)simkus(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recovering database after disk crash
Date: 2008-05-12 23:16:03
Message-ID: 29077.1210634163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2008-05-12 23:36:07 Re: changing the endianness of a database
Previous Message Andy Anderson 2008-05-12 23:04:13 Re: rounding problems