pitrery 1.6 released
====================
pitrery is a set of Bash scripts to manage PITR backups for PostgreSQL.
pitrery automates Continuous Archiving and Point-in-Time Recovery
(PITR) as much as possible with the following goals:
* Handle only PITR, log-shipping and replication are out of scope
* Be as minimally intrusive as possible for archiving
It is free software licensed under the PostgreSQL License and works
with PostgreSQL versions 8.2 through 9.3.
The main features are:
* Produce base backups and store them locally or on an SSH reachable
host, using tar or rsync (hardlinking previous backups to save
space)
* Make restoration easy by retrieving the most appropriate base backup
and preparing a recovery.conf file for the target date.
* Let the user choose where to restore, by relocating tablespace if
needed. A query to update the system catalogs is provided for 9.1 and
previous versions.
* Let the user tune the recovery by restoring a cluster ready to be
started.
* Configurable compression options for WAL file archiving.
* Time- and count-based purge including archive cleaning.
Get more information, docs, downloads at
http://dalibo.github.io/pitrery/
The project started in 2011, but I never found the time to announce
it...
pitrery is considered pretty complete, the next releases will most
likely only be maintenance releases. Feedback & contributions are
still very welcome!
--
Nicolas Thauvin
http://dalibo.com - http://dalibo.org