Re: corruption diag/recovery, pg_dump crash - Mailing list pgsql-general

From Ed Loehr
Subject Re: corruption diag/recovery, pg_dump crash
Date
Msg-id 200312080846.09236.pgsql@bluepolka.net
Whole thread Raw
In response to Re: corruption diag/recovery, pg_dump crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Monday December 8 2003 8:23, you wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > Now I am finally getting a good look at
> > the corruption (which appears to have moved around during the scp):
>
> Hm.  I don't see anything particularly exceptionable in pg_class page 11
> --- rather a lot of dead tuples, but that's not proof of corruption.
> To judge by your SELECT results, there are *no* live tuples in pg_class
> between pages 11 and 543, and a bad page header in page 543.  What do
> you see if you ask pg_filedump to dump all that page range?  (It'd be
> a bit much to send to the list, but you can send it to me off-list.)

This is pg_class; look at the ascii names on the right.  I notice that one
name (misc_doctors) is repeated twice.  We also have an error dumping that
table in which the end of the dump gets two BLANK tuples in the output,
causing the load to fail due to missing columns.  Is it possible that we
have two pg_class tuples with same relname, and if so, is that a
corruption?

Will send full dump...

TIA


Ed


pgsql-general by date:

Previous
From: cadancer
Date:
Subject: Help with Turning debugging on/off
Next
From: "Luke Woollard"
Date:
Subject: Re: [PHP] CMS with PostgreSQL