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

From Matthias.Pitzl@izb.de
Subject Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
Date
Msg-id 11EC9A592C31034C88965C87AF18C2A70CFC55@m0000s61
Whole thread Raw
Responses Re: Strange database corruption with PostgreSQL 7.4.x on
Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
List pgsql-general
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?

Best regards,
Matthias

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: vista
Next
From: Scott Marlowe
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x on