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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: Wednesday, September 20, 2006 4:32 PM > To: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Strange database corruption with > PostgreSQL 7.4.x on Debian Sarge > > > [EMAIL PROTECTED] 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
