Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL
Switch branches/tags
Nothing to show
Clone or download
Latest commit 65ba02c Jul 21, 2016



Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL

  • Version: 1.2

  • Based on an idea by Simon Riggs

  • Authors: Gabriele Bartolini, Marco Nenciarini and Simon Riggs


pgespresso is an extension that adds functions and views to be used by Barman, the disaster recovery tool written by 2ndQuadrant and released as open source (http://www.pgbarman.org/).

Supported PostgreSQL and Barman versions

This extension requires at least Barman 1.3.1. Supported PostgreSQL versions are 9.2, 9.3, 9.4 and 9.5.

Starting from PostgreSQL 9.6 this extension is not required anymore because a similar API is implemented in the PostgreSQL’s core.


To install pgespresso from sources, type:

make install

pgespresso can be installed in a specific database using the following command:


Available functions

pgespresso_start_backup (label, fast)

pgespresso_start_backup is used to start taking a concurrent backup. It returns a backup label file that the user is responsible for placing in the $PGDATA of the backup AFTER the backup has been taken. The label file must not be written to the data directory of the server from which the backup is taken because this type of backup presumes and allows that more than one backup may be in progress at any one time. The label file contains the user-supplied label string (typically this would be used to tell where the backup dump will be stored) and the starting time and starting WAL location for the dump.

pgespresso_stop_backup (label_content)

pgespresso_stop_backup is used to stop a concurrent backup. It returns the XLOG filename containing end of backup location, combining both the TLI and the end location.[1]

pgespresso_abort_backup ()

pgespresso_abort_backup aborts a running concurrent backup.


pgespresso is free software. See COPYING for details.

1. The user is responsible for ensuring that the last file is correctly archived.