Re: Where art thou pg_clog? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Where art thou pg_clog?
Date
Msg-id 20070215214653.GU4682@alvh.no-ip.org
Whole thread Raw
In response to Where art thou pg_clog?  (Casey Duncan <casey@pandora.com>)
Responses Re: Where art thou pg_clog?  (Casey Duncan <casey@pandora.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: postgresql 8.2 Installation error at "gmake"
Next
From: Peter Eisentraut
Date:
Subject: Re: Where art thou pg_clog?