Re: corruption diag/recovery, pg_dump crash

On Monday December 8 2003 8:23, you wrote:
> "Ed L." <pgsql(at)bluepolka(dot)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