From: Scott Whitney <scott@journyx.com>
To: pgsql-admin@postgresql.org
Subject: pg_clog not getting cleared
Date: Tue, 21 Dec 2010 14:24:53 -0600 (CST)
Message-ID: <3784661.2704.1292963093042.JavaMail.root@zimbra.int.journyx.com> (raw)
In-Reply-To: <16384123.2701.1292963013966.JavaMail.root@zimbra.int.journyx.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com
Subject: Re: pg_clog not getting cleared
In-Reply-To: <3784661.2704.1292963093042.JavaMail.root@zimbra.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox