Thread: Re: Strange database corruption with PostgreSQL 7.4.x o

Hello Tom!

Not yet, but i will try this one too. Anything special i should look for
when dumping out the bad pages?

-- Matthias

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: Wednesday, September 20, 2006 4:32 PM
> To: Matthias.Pitzl@izb.de
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Strange database corruption with
> PostgreSQL 7.4.x on Debian Sarge
>
>
> Matthias.Pitzl@izb.de writes:
> > invalid page header in block 437702 of relation "xxxx"
>
> I concur with Scott that this sounds suspiciously like a hardware
> problem ... but have you tried dumping out the bad pages with
> pg_filedump or even just od?  The pattern of damage would help to
> confirm or disprove the theory.
>
> You can find pg_filedump source code at
> http://sources.redhat.com/rhdb/
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

Matthias.Pitzl@izb.de writes:
> Not yet, but i will try this one too. Anything special i should look for
> when dumping out the bad pages?

"If we knew what it was we would learn, it wouldn't be research" ...

            regards, tom lane