Re: error

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