Re: How to manage WAL - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How to manage WAL
Date
Msg-id 4B7437B1020000250002F1FD@gw.wicourts.gov
Whole thread Raw
In response to How to manage WAL  (Albert Shih <Albert.Shih@obspm.fr>)
Responses Re: How to manage WAL
List pgsql-admin
Albert Shih <Albert.Shih@obspm.fr> wrote:

> I would like to known what's best way to manage the WAL.

You should design a policy which meets your particular needs.  We
keep two PITR base backups and all the WAL files from before the
start of the first (based on the information in the backup file)
through current.  We also save monthly archival PITR base backups
with just the WAL files needed to restore them (again, based on the
backup files).  Your needs may be different.

-Kevin

pgsql-admin by date:

Previous
From: Albert Shih
Date:
Subject: Re: pg_xlog
Next
From: Albert Shih
Date:
Subject: Re: How to manage WAL