Hello!
PostgreSQL 8.1.1 on x86_64-pc-linux-gnu
I've been running a server with autovacuum enabled for quite a while now (months) without problems. But recently the server slowed down and after investigation I found the following repeated error messsage in the log:
LOG: autovacuum: processing database "template0"
ERROR: could not access status of transaction 3541181801
DETAIL: could not open file "pg_clog/0D31": No such file or directory
I assume that the avac-process halts at this point which means no vacuum and/or analyze for the other databases? Which would explain the slowdown.
What is the best way to proceed with this? Stop the postmaster, create a zero-filled pg_clog/0D31 and restart?
Regards
Nichlas