Re: pg_clogs hanging around - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: pg_clogs hanging around
Date
Msg-id 4D77904C020000250003B703@gw.wicourts.gov
Whole thread Raw
In response to pg_clogs hanging around  (Scott Whitney <scott@journyx.com>)
List pgsql-admin
Scott Whitney <scott@journyx.com> wrote:

> my pg_clog directory contains files going back to Jul 13 of 2010.
>
> Every Saturday, I run:
>
> "vacuumdb -a -v -F"
>
>
> I _thought_ that was supposed to clear those out. Am I wrong?

SELECT datname, datfrozenxid FROM pg_database;

to see which database is causing them to be retained.

-Kevin

pgsql-admin by date:

Previous
From: Scott Whitney
Date:
Subject: pg_clogs hanging around
Next
From: Dinesh Bhandary
Date:
Subject: hiding metadata information from a user