pg_clog not getting cleared - Mailing list pgsql-admin

From Scott Whitney
Subject pg_clog not getting cleared
Date
Msg-id 3784661.2704.1292963093042.JavaMail.root@zimbra.int.journyx.com
Whole thread Raw
Responses Re: pg_clog not getting cleared
List pgsql-admin
Hello. I posted this once before, but I'm encountering it again.

Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time.

However, my pg_clog directory lists clog files going back to July.

This is pg 8.4.4 on Linux (CentOS 5.5).

I know this isn't a whole lot of information at this time. What more would be useful in finding out what's failing and where?

I seem to recall that doing vacuumdb -f -a -v resolved it, which would seem to point to a database not being vacuumed, but that's sort of the point of the -a switch, right? I'm running this as the "postgres" user himself.


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: size of the database
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_clog not getting cleared