Re: error

I've had no system crashes.  I'm embarrassed to say that I may have
inadvertently caused this problem when I was do "house cleaning" a
couple of weeks ago.

When I upgrade, how to I get my data when pg_dumpall won't run?

Carol

On Sep 23, 2008, at 10:42 PM, Tom Lane wrote:

> Carol Walter <walterc@indiana.edu> writes:
>> What would cause this error?
>
>> ERROR:  could not access status of transaction 10274530
>> DETAIL:  Could not open file "pg_clog/0009": No such file or
>> directory.
>
> We've seen that caused by bugs that made Postgres throw away clog
> files
> too soon; but as far as I know those bugs were all squashed in recent
> releases.  What PG version is this?  What files *are* present in
> pg_clog, and what are their mod times?  Have you had any system
> crashes
> recently?
>
>             regards, tom lane