pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres pg_attribute error
2+ messages / 2 participants
[nested] [flat]

* Postgres pg_attribute error
@ 2004-12-06 16:02 John Gierchak <JGierchak@rlwinc.com>
  2004-12-07 00:34 ` Re: Postgres pg_attribute error Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: John Gierchak @ 2004-12-06 16:02 UTC (permalink / raw)
  To: pgsql-admin

Hello all, 

I have googled my head off and can not find something that relates to
this.
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?

This is postges 7.2 running on redhat 7.3.  

Thanks for the help ahead of time
 

John Gierchak III
Software Engineer

RLW INC.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres pg_attribute error
  2004-12-06 16:02 Postgres pg_attribute error John Gierchak <JGierchak@rlwinc.com>
@ 2004-12-07 00:34 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-12-07 00:34 UTC (permalink / raw)
  To: John Gierchak <JGierchak@rlwinc.com>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-07 00:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-06 16:02 Postgres pg_attribute error John Gierchak <JGierchak@rlwinc.com>
2004-12-07 00:34 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox