Re: Warm Standby looking for already applied log files

"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