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