Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge - Mailing list pgsql-general

From Tom Lane
Subject Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
Date
Msg-id 2786.1158762695@sss.pgh.pa.us
Whole thread Raw
In response to Strange database corruption with PostgreSQL 7.4.x on Debian Sarge  (Matthias.Pitzl@izb.de)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x o
Next
From: Tom Lane
Date:
Subject: Re: Memory efficient insertion/retrieval of bytea