Search Postgresql Archives

Re: Recovering database after disk crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux