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 [EMAIL PROTECTED] www.digital-concepts.com Mobil: +43 699 / 20 88 13 51 Büro: +43 732 / 77 27 27 ------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
