Re: PostgreSQL 8.1.0 catalog corruption - Mailing list pgsql-hackers

From Bob Ippolito
Subject Re: PostgreSQL 8.1.0 catalog corruption
Date
Msg-id E1AB1184-B455-422F-98F5-C4BF55CA1FBD@redivi.com
Whole thread Raw
In response to Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Nov 21, 2005, at 2:42 PM, Tom Lane wrote:

> Bob Ippolito <bob@redivi.com> writes:
>> Ok, so how do I figure out which file(s) are associated with pg_class
>> so I can feed this thing?
>
> See contrib/oid2name and/or read
> http://www.postgresql.org/docs/8.1/static/storage.html

Ok, here's the pg_filedump for the pg_class table in the mochi  
database that is having the issue:

(it's also there without gz, but the gz is 228KB versus 2352KB  
uncompressed)
http://undefined.org/mochi.pg_class.filedump.gz

-bob



pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: OS X 7.4 failure
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [ADMIN] ERROR: could not read block