Table of Contents Previous Next


2 Overview

Capturing an image of a database cluster called a base backup, which is used as a starting point for recovery
Archiving the Write-Ahead Log segments (WAL files), which continuously record changes to be made to the database files
Performing Point-In-Time Recovery (PITR) to a specified transaction ID or timestamp with respect to a timeline using the base backup and the WAL files
BART utilizes the PostgreSQL pg_basebackup utility program as the underlying mechanism for creating base backups.
For information about pg_basebackup, see the PostgreSQL Core Documentation available at:
BART Host. The host system on which BART is installed. The BART operations are invoked from this host system and the database server base backups and archived WAL files are stored on this host as well.
BART User Account. Linux operating system user account you choose to run BART. The BART user account owns the BART backup catalog directory.
BART Configuration File. File in editable text format containing the configuration information used by BART.
BART Backup Catalog. File system directory structure containing all of the base backups and archived WAL files for the database servers managed by BART.
BART Backupinfo File. File in text format containing information for a BART backup. A backupinfo file resides in each backup subdirectory within the BART backup catalog.
BART Command Line Utility Program. Single, executable file named bart, which is used to commence all BART operations.
Postgres Database Cluster. Also commonly called the data directory, this is the file system directory where all of the data files related to a particular Postgres database server instance are stored. (A particular, running instance is identified by its host and port number when connecting to a database.) The database cluster is identified by the –D option when it is created, started, stopped, etc. by the Postgres initdb and pg_ctl commands. Typically by default, the initial database cluster is located in directory POSTGRES_INSTALL_HOME/data. A base backup is a copy of a database cluster. Note: The terms database cluster and database server are used somewhat interchangeably throughout this document, though a single database server can run multiple database clusters.
Postgres User Account. Operating system user account that runs the Advanced Server or PostgreSQL database server. By default, the Postgres user account is enterprisedb for Advanced Server installed in Oracle compatible mode. By default, the Postgres user account is postgres for Advanced Server installed in PostgreSQL compatible mode. For a PostgreSQL database server, this user account is also typically postgres.
Replication Database User. For each database server managed by BART, a database superuser, or a database user with replication privilege must be selected to act as the replication database user. This database user is used to connect to the database server when BART invokes pg_basebackup. The database superusers created with an initial Postgres database server installation (enterprisedb or postgres) may be used for this purpose.
Secure Shell (SSH)/Secure Copy (SCP). Linux utility programs used to log into hosts (SSH) and copy files (SCP) between hosts. A valid user account must be specified that exists on the target host and in effect, is the user account under which the SSH or SCP operations occur.
Chapter 4 provides information on how all of these components are configured and used with BART.

2 Overview

Table of Contents Previous Next