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=3D0 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 al=
l.
If it is a hardware problem as Mr. Tom Lane suggests how can I track it dow=
n?
Thanks for your help!
wiwo
--
Digital Concepts
Ideen-Konzepte-L=F6sungen
Wolfgang.Winkler@digital-concepts.com
www.digital-concepts.com
Mobil: +43 699 / 20 88 13 51
B=FCro: +43 732 / 77 27 27
-------------------------------------------------------