pg_clog questions

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема pg_clog questions
Дата
Msg-id 8511B4970E0D124898E973DF496F9B432516DE@stash.stackdump.local
обсуждение исходный текст
Ответы Re: pg_clog questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Strange errors in log file
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Strange errors in log file