Saturday, August 18

Management of the WAL archive in Barman

Gabriele's PlanetPostgreSQL
Barman, backup and recovery manager for PostgreSQL, is designed to manage the archive of WAL files separately from periodical backups (in Postgres terms, base backups). You can see this archive as a "continuous" stream of files from the first available backup to the last shipped file (backup available history for a server). In this article you will see how Barman manages WAL compression and archival, as well as how a particular WAL file is associated to a base backup in the history, granting database administrator the privilege to immediately know the exact physical size of a periodical backup (WAL files included) through the catalogue. (more…)

Barman is finally out

Gabriele's PlanetPostgreSQL
It took longer than expected, but we have finally managed to release Barman as open-source under GNU GPL 3. Barman stands for "Backup and Recovery Manager" and it is an administration tool for disaster recovery of PostgreSQL servers. Currently only Linux systems are officially supported, however Python allows to plan porting and maintenance on different platforms as well. The idea of starting Barman began about a year ago. We were tired of managing disaster recovery solutions using custom scripts, hard to maintain and to monitor (you probably know what I mean). (more…)

Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL

International News, PostgreSQL
2ndQuadrant is happy to announce the release of Barman 1.0. Barman (backup and recovery manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python for Linux systems. It allows remote backups of multiple Postgres servers in business critical environments and helps database administrators during the recovery phase. Barman's most wanted features include backup catalogues, retention policies, remote recovery, archiving and compression of WAL files and backups. (more…)