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.