Обсуждение: Postgres 9.2 pg_xlog cleanup

Поиск
Список
Период
Сортировка

Postgres 9.2 pg_xlog cleanup

От
Marcello Lorenzi
Дата:
Hi All,
I'm installing a new Postgres 9.2 instance on my test environment and I
noticed that the pg_xlog directory use a lot of space. I already
configured the WAL but not the archiving for this datsa. Is it possible
to implement a retention on pg_xlog data files?

Thanks,
Marcello

Re: Postgres 9.2 pg_xlog cleanup

От
Raghu Ram
Дата:

On Wed, Nov 27, 2013 at 9:27 PM, Marcello Lorenzi <mlorenzi@sorint.it> wrote:

Hi All,
I'm installing a new Postgres 9.2 instance on my test environment and I noticed that the pg_xlog directory use a lot of space. I already configured the WAL but not the archiving for this datsa. Is it possible to implement a retention on pg_xlog data files?

 
WAL buffers holds the changes made to the database in the transaction logs(pg_xlogs), in order to guarantee transaction security. When a transaction commits,all transaction records are stored in to disk/permanent storage i.e Pg_xlog directory. 

I would request to monitor database server log file located under "pg_log" directory,may be archive command failing due to that .ready files are increasing under ../pg_xlog/archive_status directory and occupying more space. If you fix the archive command issues,then everything will comes under control.

Thanks & Regards
Raghu Ram


 

Re: Postgres 9.2 pg_xlog cleanup

От
Ray Stell
Дата:

On Nov 27, 2013, at 10:57 AM, Marcello Lorenzi <mlorenzi@sorint.it> wrote:

 Is it possible to implement a retention on pg_xlog data files?

"wal_keep_segments (integer)  Specifies the minimum number of past log file segments kept in the pg_xlog directory"
Вложения