How to repair 'could not access status of transaction '

From: "Lane Rollins" <laner(at)boyds(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to repair 'could not access status of transaction '
Date: 2004-11-18 19:35:38
Message-ID: 1111315954-40710505@boyds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Currently on 7.4.2, I see that 7.4.6 seems to solve the problem. But I need
to repair the database. I can survive the loss of a transaction or two.
Bottom line is how do I repair the problem.

Actual error message

ERROR: could not access status of transaction 830358855

DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0317": No such
file or directory

The file does not exist.

Thanks,

Lane Rollins

Boyd Coffee Co.

Browse pgsql-admin by date

  From Date Subject
Next Message Di Croce, Tony 2004-11-19 00:23:50 Stamping rows...
Previous Message Andrew Sullivan 2004-11-18 15:41:46 Re: Usenet Discussion Proposal