PostgreSQL Point In Time Recovery made easy
Shell Groff Makefile
Permalink
Failed to load latest commit information.
debian Bump version to prepare release 1.12 Nov 20, 2016
rpm Bump version to prepare release 1.12 Nov 20, 2016
.gitattributes Add a .gitattributes Oct 31, 2015
.gitignore New configure action Mar 13, 2016
CHANGELOG bump version to 1.13-dev and update changelog Dec 8, 2016
CONTRIBUTORS Update CONTRIBUTORS file Jun 2, 2016
COPYRIGHT update copyright for 2016 Feb 19, 2016
INSTALL.md archive_xlog: new option set to chmod the archived files Nov 16, 2016
INSTALL_fr.md archive_xlog: new option set to chmod the archived files Nov 16, 2016
Makefile New configure action Mar 13, 2016
README.md madtibo: correction orthographiques dans les .md Nov 9, 2016
README_fr.md madtibo: correction orthographiques dans les .md Nov 9, 2016
TODO Bump version to prepare release 1.12 Nov 20, 2016
UPGRADE.md archive_xlog: remove support of deprecated compression parameters Nov 18, 2016
UPGRADE_fr.md archive_xlog: remove support of deprecated compression parameters Nov 18, 2016
archive_xlog.1.man archive_xlog: new option set to chmod the archived files Nov 16, 2016
archive_xlog.bash archive_xlog: remove support of deprecated compression parameters Nov 18, 2016
backup_pitr.bash backup: copy PG_VERSION Jun 20, 2016
check_pitr.bash force the use -X when calling psql May 17, 2016
config.mk bump version to 1.13-dev and update changelog Dec 8, 2016
configure_pitr.bash force the use -X when calling psql May 17, 2016
list_pitr.bash compatibility fixes for older bash versions May 12, 2016
pitr.conf.sample Update changelog and docs Nov 20, 2016
pitrery.1.man backup: optionally name backups dir with ISO 8601 timestamps Apr 20, 2016
pitrery.bash backup: optionally name backups dir with ISO 8601 timestamps Apr 20, 2016
purge_pitr.bash compatibility fixes for older bash versions May 12, 2016
restore_pitr.bash restore: remove tablespace_map, it interferes with tablespace relocation Dec 1, 2016
restore_xlog.1.man translate path in manpages with make Dec 22, 2015
restore_xlog.bash compatibility fixes for older bash versions May 12, 2016

README.md

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

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

  1. Get the source

  2. Edit the config.mk

  3. Run make and make install

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

  5. Configure WAL archiving (archive_command = 'archive_xlog -C pitr %p') in PostgreSQL

  6. 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 Nicolas Thauvin 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

A mailing list is also available: pitrery@librelist.com