From: | "Casey T(dot) Deccio" <casey(at)deccio(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Transaction error |
Date: | 2005-09-01 16:26:02 |
Message-ID: | 1125591962.14226.32.camel@boomerang.ran.sandia.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 2005-09-01 at 11:59 -0400, Tom Lane wrote:
> "Casey T. Deccio" <casey(at)deccio(dot)net> writes:
> > I recently shut down my machine (as far as I know, it went down
> > cleanly). When I brought it back up, one of my databases was messed
> > up. Here is the error I get when I try to select:
>
> > ERROR: could not access status of transaction 4114057
> > DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0003": No
> > such file or directory
>
> > I tried restoring a backup of the data directory that did contain the
> > 0003 file, but that didn't work either.
>
> Define "didn't work" ... what happened, exactly, when you tried it?
>
Sorry, I was too tired last night to try it again and post the error.
Here it is:
ERROR: could not access status of transaction 4114057
DETAIL: could not read from file "/var/lib/postgres/data/pg_clog/0003"
at offset 237568: Success
> People have occasionally dealt with this sort of scenario by creating
> dummy clog segment files by hand, and I'd think that restoring the
> segment file from a backup would do as well or better.
>
How would I create a dummy clog segment file, if needed?
Regards,
Casey
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-09-01 16:43:21 | Re: Schema problems RedHat / SuSE 9.3 for version 7.4.8 |
Previous Message | Michael Fuhr | 2005-09-01 16:13:44 | Re: Don't understand transaction error |