A nightmare

From: Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: A nightmare
Date: 2005-05-02 06:19:28
Message-ID: 1115014768.8003.9.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin


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


Browse pgsql-admin by date

  From Date Subject
Next Message Lentes, Bernd 2005-05-02 07:40:17 Re: Suse 9.2 stops booting while starting the postgres-server
Previous Message Gourish Singbal 2005-05-02 05:11:52 Re: measuring most-expensive queries