"Kevin Grittner" <[email protected]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
