Re: Where art thou pg_clog?

Casey Duncan wrote:
> We have a production system with multiple identical database
> instances on the same hardware, with the same configuration, running
> databases with the exact same schema. They each have different data,
> but the database sizes and load patterns are almost exactly the same.
>
> We are running pg 8.1.5 (upgraded the day before 8.1.6 came out, oh
> well ;^) and since then we have noticed the following error on two of
> the servers:
>
> 2007-02-15 00:35:03.324 PST ERROR:  could not access status of
> transaction 2565134864
> 2007-02-15 00:35:03.325 PST DETAIL:  could not open file "pg_clog/
> 098E": No such file or directory

Can you relate it to autovacuum?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.