thank you all. There is a mistake I did then. I created a base backup when I started the DB , that was exactly an year ago. I need to do that again and then delete the old files.
Regards On Wed, Dec 5, 2012 at 4:25 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > akp geek <akpg...@gmail.com> writes: > > WAL archives is growing, not the files in pg_xlog. > > You need to prune the archives of files that are too old to be > interesting. This doesn't happen automatically since PG has no > idea what your archiving requirements are. > > Be sure to keep WAL files at least back to the start of your > last base backup. Some people like to keep them back to the > next-to-last base backup. > > regards, tom lane >