Re: ERROR: could not access status of transaction 2495690984

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not access status of transaction 2495690984
Date: 2009-07-21 19:32:07
Message-ID: b42b73150907211232h50ba4099k1c8d0d5885640952@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/7/21 Bjørn T Johansen <btj(at)havleik(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2009-07-21 21:36:21 Re: suggestion: log_statement = sample
Previous Message Merlin Moncure 2009-07-21 19:28:34 Re: suggestion: log_statement = sample