While checking our server, I noticed quite a few files in the pg_clog
directory.

These files date from today back to the day when I installed PostgreSQL.

Is there a maintenance task which can be run to purge the files which
are no longer needed?

I assume the majority of them are not needed, since the data has already
been commited.



I back up nightly with pg_dump, but this obviously does not reset these
files.

Do I need to do a backup with archiving in order to clear these out?



TIA,



Benjamin

"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> While checking our server, I noticed quite a few files in the pg_clog
> directory.

> Is there a maintenance task which can be run to purge the files which
> are no longer needed?

VACUUM. If they're not disappearing, you aren't running an adequate
vacuum regime --- missing out some databases, perhaps?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org