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, up to 12 included.
It is free software licensed under the PostgreSQL License.
Get pitrery either by debian / RPM package or by getting the source / compiling and installing it
pitrery configure -o pitrery -f [[user@]host:]/path/to/backups
(user@host being optional)
Configure WAL archiving (
archive_command = 'archive_wal %p' and friends)
pitrery to perform your backups and restores