A nightmare - Mailing list pgsql-admin

From Mauri Sahlberg
Subject A nightmare
Date
Msg-id 1115014768.8003.9.camel@localhost.localdomain
Whole thread Raw
Responses Re: A nightmare  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

I'm starting to become desperate. On saturday I dumped all databases,
wiped whole postgresql installation. Installed newest rpms for Fedora 1,
restored databases. Recompiled client libraries and binaries. Restarted
and after five hours of operation:
May  1 21:34:19 claymountain postgres[6337]: [2-1] ERROR:  could not
access status of transaction 4250811410
May  1 21:34:19 claymountain postgres[6337]: [2-2] DETAIL:  could not
open file
"/var/lib/pgsql/data/pg_clog/0FD5": No such file or directory

Is there anything else I could do than dump, wipe, restore again? Isn't
there anything I could do to try to get more detailed meaningful
information on why this is happening?

All that the log shows before this happening are a few unexpected client
disconnections.


pgsql-admin by date:

Previous
From: Gourish Singbal
Date:
Subject: Re: measuring most-expensive queries
Next
From: "Holger Hoffstaette"
Date:
Subject: Re: measuring most-expensive queries