Awesome

pitrery: Point-In-Time Recovery (PITR) tools for PostgreSQL

WARNING : PITRERY IS IN MAINTENANCE-ONLY MODE

After 10 years of development, pitrery's development status is now Long Term Support (LTS). New features will no longer be added to Pitrery. We will continue to develop bug fixes and security fixes if need be.

Pitrery supports PostgreSQL versions from 9 up to 14 but will not work on PostgreSQL 15 and following because the backup API has evolved.

LTS period will end as of december 2026.

FEATURES

pitrery is set of tools to ease the management of PITR backups and restores:

Management of WAL segments archiving with compression to a host reachable with SSH or on the local machine
Automation of the base backup procedure
Restore to a particular date
Management of backup retention

QUICK SETUP

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_wal %p') in PostgreSQL
Run pitrery to perform your backups and restores

The full documentation is available in man pages, INSTALL.md or the website :

http://dalibo.github.io/pitrery/

DEVELOPMENT

The source code is available on Github: https://github.com/dalibo/pitrery

pitrery is developed by Dalibo under a classic 2 clauses BSD license. See license block in the scripts or the COPYRIGHT file.

HOW TO CONTRIBUTE

Any contribution is welcome. If you have any idea, feature request, question or patch, please contact us on Github:

https://github.com/dalibo/pitrery/issues