Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: 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. 


Responses

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group