Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> We had one of our databases suddenly try to reference a pg_clog
> file that didn't exist whenever we attempted to select from a certain
> table. Anyone know of a way to recover from this?
You need to provide more details. For one, exactly which PG version
are you using? And is the complained-of clog file newer or later than
the range of files actually present in $PGDATA/pg_clog?
regards, tom lane