Point In Time Recovery tools for PostgreSQL
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 config.mk
, run make
and make install
Run 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
Run pitrery
to perform your backups and restores