pitrery is a set of Bash scripts to manage Point In Time Recovery (PITR) backups for PostgreSQL.
pitrery automates Continuous Archiving and Point-in-Time Recovery (PITR) as much as possible with the following goals:
Pitrery has been tested and works with all currently supported versions of PostgreSQL.
It is free software licensed under the PostgreSQL License.
Get the source, edit the
pitrery configure -o pitrery -f [[user@]host:]/path/to/backups (user@host being optional)
Configure WAL archiving (
archive_command = 'archive_xlog %p' and friends) in PostgreSQL
pitrery to perform your backups and restores