Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias(dot)Pitzl(at)izb(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
Date: 2006-09-20 14:31:35
Message-ID: 2786.1158762695@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthias(dot)Pitzl(at)izb(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-09-20 14:38:19 Re: Memory efficient insertion/retrieval of bytea
Previous Message Tomasz Ostrowski 2006-09-20 14:20:46 Re: Strange database corruption with PostgreSQL 7.4.x o