| 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
| 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 |