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 23:19:35
Message-ID: FA72171E-8B21-4ED6-B6A6-33BD30A44DF6@redivi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Nov 21, 2005, at 3:12 PM, Tom Lane wrote:

> Bob Ippolito <bob(at)redivi(dot)com> writes:
>> Ok, here's the pg_filedump for the pg_class table in the mochi
>> database that is having the issue:
>
> Thanks. I don't see any live tuples that look like they could have
> been
> the one we want, but there's a whole lot of deleted rows, which
> pg_filedump won't show with those options. Could you try a
> pg_filedump
> with -d option too?

Sure, here it is:

http://undefined.org/mochi.pg_class-1.filedump.gz

-bob

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2005-11-21 23:24:39 Re: [ADMIN] ERROR: could not read block
Previous Message Jim C. Nasby 2005-11-21 23:17:51 Re: CLUSTER and clustered indices