Re: wal archiving question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal archiving question
Date: 2012-12-05 21:25:48
Message-ID: 13059.1354742748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

akp geek <akpgeek(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2012-12-05 21:29:29 Re: wal archiving question
Previous Message akp geek 2012-12-05 20:43:09 Re: wal archiving question