Re: Postgres pg_attribute error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John Gierchak" <JGierchak(at)rlwinc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres pg_attribute error
Date: 2004-12-07 00:34:10
Message-ID: 8439.1102379650@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"John Gierchak" <JGierchak(at)rlwinc(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message darren 2004-12-07 02:55:18 DRBD with Postgres: Good or Bad?
Previous Message dedy 2004-12-07 00:26:18 test