pgespresso

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

Introduction

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.

Installation

To install pgespresso from sources, type:

make
make install

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

CREATE EXTENSION pgespresso;

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.

License

pgespresso is free software. See COPYING for details.

---

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