Ingeniero

Barman
Backup and Recovery Manager for
PostgreSQL Tutorial

2 July 2012
Gabriele Bartolini
Marco Nenciarini
Carlo Ascani
Gianni Ciolli

Barman: Backup and Recovery Manager for PostgreSQL
Tutorial

Revision History
Revision 1.0.0

2 July 2012

gb, ca, mn, gc

First public release
Copyright © 2012, 2ndQuadrant Italia (Devise.IT S.r.l.) - http://www.2ndQuadrant.it/. All rightsreserved.
The PostgreSQL elephant logo "Slonik" ® is a registered trademark of the PostgreSQL Global Development Group.

Table of Contents
Introduction .............................................................................................................................. 3
Before you start....................................................................................................................... 3
System requirements ........................................................................................................ 4
Installation ................................................................................................................................ 4
Getting started......................................................................................................................... 5
Prerequisites .................................................................................................................... 5
Basic configuration ........................................................................................................... 6
Listing the servers............................................................................................................ 7
Executing a full backup ..................................................................................................... 7
Viewing the list of backups for a server ............................................................................. 7
Restoring a whole server.................................................................................................. 7
Remote recovery .............................................................................................................. 8
Restoring to a given point in time ...................................................................................... 8
WAL compression.................................................................................................................... 9
Available commands ................................................................................................................. 9
General commands .......................................................................................................... 9
Server commands ........................................................................................................... 10Backup commands ......................................................................................................... 10
Support and sponsor opportunities .......................................................................................... 11
Authors .................................................................................................................................. 11License and Contributions ....................................................................................................... 11

Copyright © 2012, 2ndQuadrant Italia

2

Barman: Backup and Recovery Manager for PostgreSQL
Tutorial

Barman (backup and recovery manager) is an administration tool for disaster recovery of PostgreSQL
servers written in Python. Barman can perform remotebackups of multiple servers in business critical
environments, and helps DBAs during the recovery phase.
Barman’s most wanted features include: backup catalogues, retention policies, remote recovery,
archiving and compression of WAL files and of backups. Barman is written and maintained by
PostgreSQL professionals 2ndQuadrant.

Introduction
In a perfect world, there would be no need for a...