Re: PostgreSQL 8.1.0 catalog corruption

From: Bob Ippolito <bob(at)redivi(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1.0 catalog corruption
Date: 2005-11-21 22:50:39
Message-ID: E1AB1184-B455-422F-98F5-C4BF55CA1FBD@redivi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Nov 21, 2005, at 2:42 PM, Tom Lane wrote:

> Bob Ippolito <bob(at)redivi(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-21 23:05:57 Re: [HACKERS] ERROR: could not read block
Previous Message Tom Lane 2005-11-21 22:42:39 Re: PostgreSQL 8.1.0 catalog corruption