Re: wal archiving question - Mailing list pgsql-general

From Tom Lane
Subject Re: wal archiving question
Date
Msg-id 13059.1354742748@sss.pgh.pa.us
Whole thread Raw
In response to Re: wal archiving question  (akp geek <akpgeek@gmail.com>)
Responses Re: wal archiving question  (akp geek <akpgeek@gmail.com>)
List pgsql-general
akp geek <akpgeek@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


pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: wal archiving question
Next
From: akp geek
Date:
Subject: Re: wal archiving question