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