how to truncate/purge the pg_xlog directory?

Поиск
Список
Период
Сортировка
От tfinneid@student.matnat.uio.no
Тема how to truncate/purge the pg_xlog directory?
Дата
Msg-id 47138.134.32.140.234.1192180985.squirrel@webmail.uio.no
обсуждение исходный текст
Ответы Re: how to truncate/purge the pg_xlog directory?
Список pgsql-general
Hi

As far as I understand pg_xlog  is the transaction log i.e. the WAL.

I have a pg 8.2 which has consumed about 113MB in pg_xlog/, while the
cluster is virtually empty. There are a couple of tables in the postgres
schema, but they contain no data at the moment. My disk is filling up and
I want to purge directories that are larger than need to be.
I performed a VACUUM FULL, because I thought that would help, but it did not.
I searched the net and the forums here and found only one post about
tuning the wal parameters to control the pg_xlog directory size, but when
looking at the documentation for that I found nothing that could be used
for that

Also the base/ directory is 268MB big and still not many tables, is ti
possible to purge that directory as well?.

I would appreciate some help on what to do.

regards

thomas



В списке pgsql-general по дате отправления:

Предыдущее
От: longlong
Дата:
Сообщение: Re: silent install
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: how to truncate/purge the pg_xlog directory?