On Wed, Nov 27, 2013 at 9:27 PM, Marcello Lorenzi <mlorenzi@xxxxxxxxx> 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
