Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres pg_attribute error - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres pg_attribute error
Date
Msg-id 8439.1102379650@sss.pgh.pa.us
Whole thread Raw
In response to Postgres pg_attribute error  ("John Gierchak" <JGierchak@rlwinc.com>)
List pgsql-admin
Tree view 
"John Gierchak" <JGierchak@rlwinc.com> writes:
> Here is the error: " ERROR:  cannot read block 13 of pg_attribute:
> Success "
> I can not dump the database, reindex or even select from the tables.   I
> also get "relation 1249 is nailed" sometimes.  Any ideas on what I
> should do?

Restore from backup ... looks like your filesystem lost part of the
system catalogs.

            regards, tom lane

pgsql-admin by date:

Previous
From: "mlaks@verizon.net"
Date:
Subject: psql instead of pg_restore
Next
From: "dedy"
Date:
Subject: test