pg_clog questions - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject pg_clog questions
Date
Msg-id 8511B4970E0D124898E973DF496F9B432516DE@stash.stackdump.local
Whole thread Raw
Responses Re: pg_clog questions
List pgsql-admin

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

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Strange errors in log file
Next
From: Scott Marlowe
Date:
Subject: Re: Strange errors in log file