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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane > Sent: Wednesday, September 20, 2006 4:32 PM > To: Matthias.Pitzl@xxxxxx > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] Strange database corruption with > PostgreSQL 7.4.x on Debian Sarge > > > Matthias.Pitzl@xxxxxx 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 >
