- pgespresso 1.2.0
- Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL
Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL
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.
pgespresso from sources, type:
make make install
pgespresso can be installed in a specific database using
the following command:
CREATE EXTENSION pgespresso;
pgespresso_start_backup (label, fast)
pgespresso_start_backupis 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_backupis used to stop a concurrent backup. It returns the XLOG filename containing end of backup location, combining both the TLI and the end location.
[The user is responsible for ensuring that the last file is correctly archived.]
pgespresso_abort_backupaborts a running concurrent backup.
pgespresso is free software. See COPYING for details.