autovacuum template0

From: Jacob Coby <jcoby(at)listingbook(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: autovacuum template0
Date: 2006-06-22 20:43:52
Message-ID: 449B0108.4090907@listingbook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a pg 8.1.1 server running autovacuum, and it started attempting
to vacuum template0.

2006-06-22 15:00:50 EDT LOG: autovacuum: processing database "template0"
2006-06-22 15:00:50 EDT ERROR: could not access status of transaction
3242180415
2006-06-22 15:00:50 EDT DETAIL: could not open file "pg_clog/0C13": No
such file or directory

I found a thread about the same problem at
http://archives.postgresql.org/pgsql-hackers/2006-03/msg01294.php, but
it doesn't say if the resolution works. Does anyone have experience
with this? I'm at a loss as to what I should do.

Thanks,
--
Jacob Coby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Todd A. Cook 2006-06-22 20:48:45 Re: Out of memory error in 8.1.0 Win32
Previous Message Dylan Hansen 2006-06-22 20:42:39 Re: auto-vacuum & Negative "anl" Values