PgBackMan is a tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall.

It is designed to manage backups from thousands of databases running in multiple PostgreSQL nodes, and it supports a multiple backup server topology.

PgBackMan is distributed under the GNU General Public License 3.

Main Features

  • Central database with metadata information.
  • PgBackMan shell for interaction with the system.
  • Management of multiple backup servers.
  • Management of multiple PostgreSQL servers.
  • Management of thousands of backups dumps through a catalogue.
  • Manual and scheduled backups.
  • Management of retention policies for backups dumps.
  • Fully detailed backup reports.
  • Multiple predefined database backup types, CLUSTER, FULL, SCHEMA, DATA.
  • Full backup of role information for a database.
  • Full backup of database configuration for a database.
  • Automatic definitions of backups for all databases running in a PgSQL node.
  • Automatic definitions of backups for all databases without definitions in a PgSQL node.
  • Automatic deletion after a quarantine period of backup definitions and associated files for databases than have been deleted in a PgSQL node.
  • Possibility of pausing / resuming replication on slaves/standby nodes when taking large backups.
  • Automatic restore procedures.
  • Autonomous pgbackman_dump program that functions even if the central database with metadata is not available.
  • Possibility of sending alerts via SMTP when an error happens.
  • Handling of error situations.
  • Written in Python and PL/PgSQL
File your Bug report / Feature request on the issue page of the project

GitHub / pgbackman

Documentation

The PgBackMan manual is available in HTML and PDF formats. The source code of the documentation in RST format is also available at GitHub: https://github.com/rafaelma/pgbackman/blob/master/docs/manual.rst

Downloads

The current version is 1.2.0. The source code, RPM and DEB packages for some main distributions are available at GitHub. Check the PgBackMan documentation for information about how to install and configurate this software.