pitrery

Point In Time Recovery tools for PostgreSQL

Welcome

Warning : Pitrery is in Maintainance-only mode

After 10 years of development, pitrery development status is now Long Term Support (LTS). Pitrery won’t have new features but bug fixes and security fixes. Pitrery will supports PostgreSQL version from 9 up to 14. PostgreSQL 15 and following won’t be officially supported.

LTS period will end as of december 2026.

Introduction

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.

Quick start

  1. Get pitrery either by debian / RPM package or by getting the source / compiling and installing it

  2. Run pitrery configure -o pitrery -f [[user@]host:]/path/to/backups (user@host being optional)

  3. Configure WAL archiving (archive_command = 'archive_wal %p' and friends) in PostgreSQL

  4. Run pitrery to perform your backups and restores

News