From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Albert Shih <Albert.Shih@obspm.fr>
To: pgsql-admin@postgresql.org
Subject: Re: How to manage WAL
Date: Thu, 11 Feb 2010 17:00:33 -0600
Message-ID: <4B7437B1020000250002F1FD@gw.wicourts.gov> (raw)
In-Reply-To: <20100211223245.GA13434@obspm.fr>
References: <20100211223245.GA13434@obspm.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, Albert.Shih@obspm.fr
Subject: Re: How to manage WAL
In-Reply-To: <4B7437B1020000250002F1FD@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox