pitrery

Point In Time Recovery tools for PostgreSQL

Welcome

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