Re: ERROR: could not access status of transaction 2495690984 - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: ERROR: could not access status of transaction 2495690984
Date
Msg-id 20090723194409.290471f5@laptop-btj
Whole thread Raw
In response to Re: ERROR: could not access status of transaction 2495690984  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Tue, 21 Jul 2009 15:32:07 -0400
Merlin Moncure <mmoncure@gmail.com> wrote:

> 2009/7/21 Bjørn T Johansen <btj@havleik.no>:
> > I have had som problem with my filesystem and now I get these error messsages when trying to access my database..:
> >
> > ERROR:  could not access status of transaction 2495690984
> > Could not open file "pg_clog/094C": No such file or directory.
>
> got backups?
>
> One way to suppress this error, but not fix the underlying corruption,
> is to generate clog files that the database thinks should be there.
> Make a 256k file filled with 0x55 and put it where the database is
> expecting.
>
> merlin
>


Yes, I have backups... Was just kind of hoping for another solution.... :)

BTJ

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: synchronous_commit=off doesn't always return immediately
Next
From: bulk
Date:
Subject: 3des key lengths and key management