From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Colin Wilson <cwilson@blackducksoftware.com>
Cc: pgsql-admin\@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Warm Standby looking for already applied log files
Date: Fri, 28 Jan 2011 16:50:08 +0100
Message-ID: <m2sjwdkoy7.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <4D3D5C520200002500039B11@gw.wicourts.gov>
References: <A51C2757-6A50-4E0A-B1C9-6E07CD4393A9@blackducksoftware.com>
<4D3D5C520200002500039B11@gw.wicourts.gov>
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> that script to not delete. Personally, I like to keep the last two
> base backups and all the WAL files needed to restore from the
> earlier of those forward. We have cleanup script that deletes the
> oldest backup and WAL files only needed for recovery from it when we
> receive a new one.
PostgreSQL 9.0 now ships with such a script per default:
http://www.postgresql.org/docs/9.0/interactive/pgarchivecleanup.html
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
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: dimitri@2ndQuadrant.fr, Kevin.Grittner@wicourts.gov, cwilson@blackducksoftware.com
Subject: Re: Warm Standby looking for already applied log files
In-Reply-To: <m2sjwdkoy7.fsf@2ndQuadrant.fr>
* 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