Introduction v2.6

Suggest edits

The EDB Backup and Recovery Tool (BART) is an administrative utility that provides simplified backup and recovery management for multiple local or remote EDB Advanced Server and PostgreSQL database servers.

BART provides the following features:

  • Support for complete, hot, physical backups of multiple Advanced Servers and PostgreSQL database servers
  • Support for two types of backups – full base backups and block-level incremental backups
  • Backup and recovery management of database servers on local or remote hosts
  • A single, centralized catalog for backup data
  • Retention policy support for defining and managing how long backups should be kept
  • The capability to store the backup data in compressed format
  • Verified backup data with checksums
  • Backup information displayed in an easy-to-read format
  • A simplified point-in-time recovery process

This guide provides the following information about using BART:

For information about installing BART, see the EDB Backup and Recovery Installation and Upgrade Guide; for examples of BART operations and subcommand usage, see the EDB Backup and Recovery Reference Guide. These guides are available at the EDB website.

Conventions Used in this Guide

The following is a list of conventions used throughout this document.

  • Much of the information in this document applies interchangeably to the PostgreSQL and EDB Advanced Server database systems. The term Advanced Server is used to refer to EDB Advanced Server. The term Postgres is used to generically refer to both PostgreSQL and Advanced Server. When a distinction needs to be made between these two database systems, the specific names, PostgreSQL or Advanced Server are used.

  • The installation directory of the PostgreSQL or Advanced Server products is referred to as POSTGRES_INSTALL_HOME:

    • For PostgreSQL Linux installations, this defaults to /opt/PostgreSQL/<x.x> for version 10 and earlier. For later versions, the installation directory is /var/lib/pgsql/<x>.
    • For Advanced Server Linux installations performed using the interactive installer for version 10 and earlier, this defaults to /opt/PostgresPlus/<x.x>AS or /opt/edb/as<x.x>. For Advanced Server Linux installations performed with an RPM package, this defaults to /usr/ppas-<x.x> or /usr/edb/as<x.x>. For Advanced Server Linux installations performed with an RPM package for version 11 or later, this defaults to /usr/edb/as<xx>.

Restrictions on pg_basebackup

BART takes full backups using the pg_basebackup utility program under the following conditions:

  • The backup is taken on a standby server.
  • The --with-pg_basebackup option is specified with the BACKUP subcommand (see Backup).
  • The number of thread count in effect is 1, and the with-pg_basebackup option is not specified with the BACKUP subcommand.
  • Database servers can only be backed up using pg_basebackup utility program of the same or later version than the database server version.

In the global section of the BART configuration file, the pg_basebackup_path parameter specifies the complete directory path to the pg_basebackup program. For information about the pg_basebackup_path parameter and the thread_count, see the EDB Backup and Recovery Installation and Upgrade Guide available at the EDB website.

For information about pg_basebackup, see the PostgreSQL Core Documentation.

← Prev

EDB Postgres Backup and Recovery User Guide

Next →

Overview