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

2006-09-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > invalid page header in block 437702 of relation "" 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 t

Re: [GENERAL] Strange database corruption with PostgreSQL 7.4.x on

2006-09-20 Thread Scott Marlowe
On Wed, 2006-09-20 at 14:34 +0200, [EMAIL PROTECTED] 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 ta

[GENERAL] Strange database corruption with PostgreSQL 7.4.x on Debian Sarge

2006-09-20 Thread Matthias . Pitzl
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 5000