Corrupted Database

Hi!

We have the same problem like this user:
http://archives.postgresql.org/pgsql-bugs/2002-12/msg00103.php

But our System is a very stable SuSE Linux 8.1 box with Postgres 7.3.2. The
problem is, that nearly once a week the database gets corrupted. Typical
problems are failing pg_dumps of certain tables. When I look into this table
there are entries with oid=0 or two entries with the same oid.

Often there are overlong tuples with a lot of garbage in it. When I'm lucky I
can delete them and everything works fine for the next few days.

The log says for example

PANIC: open of /usr/local/pgsql/data/pg_clog/0419 failed: No such file or
directory

or

ERROR: MemoryContextAlloc: invalid request size 4294967277

We have the same installations on other computers and have no problem at all.
If it is a hardware problem as Mr. Tom Lane suggests how can I track it down?

Thanks for your help!

wiwo

--
Digital Concepts
Ideen-Konzepte-Lösungen
Wolfgang(dot)Winkler(at)digital-concepts(dot)com
www.digital-concepts.com
Mobil: +43 699 / 20 88 13 51
Büro: +43 732 / 77 27 27

-------------------------------------------------------