Re: Postgres 9.2 pg_xlog cleanup

On Wed, Nov 27, 2013 at 9:27 PM, Marcello Lorenzi <mlorenzi(at)sorint(dot)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