Hello Scott! Thank you for the quick answer. I'll try to check our hardware which is a Compaq DL380 G4 with a batteyr buffered write cache on our raid controller. As the system is running stable at all i think it's not the cpu or memory. At moment i tend more to a bad disk or SCSI controller but even with that i don't get any message in my logs... Any ideas how i could check the hardware? Best regards, Matthias > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Scott Marlowe > Sent: Wednesday, September 20, 2006 2:56 PM > To: Matthias.Pitzl@xxxxxx > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] Strange database corruption with > PostgreSQL 7.4.x on > > > On Wed, 2006-09-20 at 14:34 +0200, Matthias.Pitzl@xxxxxx wrote: > > Hello! > > > > We're running the latest release of PostgreSQL 7.4.13 on a > Debian Sarge > > machine. Postgres has been compiled by oureselves. > > We have a pretty big database running on this machine, it > has about 6.4 GB > > approximately. One table contains about 55 million rows. > > Into this table we insert about 500000 rows each day. Our > problem is that > > without any obvious reason the database gets corrupt. The > messages we get > > are: > > invalid page header in block 437702 of relation "xxxx" > > We already have tried out some other versions of 7.4. On > another machine > > running Debian Woody with PotgreSQL 7.4.10 we don't have > any problems. > > Kernels are 2.4.33 on the Sarge machine, 2.4.28 on the > Woody machine. Both > > are SMP kernels. > > Does anyone of you perhaps have some hints what's going wrong here? > > Most likely causes in these cases tends to be, bad memory, bad hard > drive, bad cpu, bad RAID / IDE / SCSI controller, loss of power when > writing to IDE drives / RAID controllers with cache with no battery > backup. > > I.e. check your hardware. > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend >
