Table of Contents Previous Next

Table of Contents

1 Introduction
1.1 What’s New
1.2 Typographical Conventions Used in this Guide
1.3 Other Conventions Used in this Guide
1.3.1 Restrictions on pg_basebackup
2 Overview
2.1 Block-Level Incremental Backup
2.1.1 Incremental Backup Limitations and Requirements
2.1.2 Concept Overview
2.1.3 WAL Scanning – Preparation for an Incremental Backup
2.1.4 Performing an Incremental Backup
2.1.5 Restoring an Incremental Backup
2.1.5.1 General Restore Process for an Incremental Backup
2.1.5.2 Restoring an Incremental Backup on a Remote Host
2.1.6 Creating a Backup Chain
3 Using BART
3.1 BART Management Overview
3.1.1 Point-In-Time Recovery Operation
3.2 Managing Backups Using a Retention Policy
3.2.1 Overview
3.2.2 Marking the Backup Status
3.2.3 Setting the Retention Policy
3.2.3.1 Redundancy Retention Policy
3.2.3.2 Recovery Window Retention Policy
3.2.4 Managing the Backups
3.2.4.1 Deletions Permitted Under a Retention Policy
3.2.4.2 Marking Backups for Indefinite Keep Status
3.2.4.3 Evaluating, Marking, and Deleting Obsolete Backups
3.2.5 Managing Incremental Backups
3.2.5.1 Redundancy Retention with Incremental Backups
3.2.5.2 Recovery Window Retention with Incremental Backups
3.3 Basic BART Subcommand Usage
3.4 BART Subcommands
3.4.1 CHECK-CONFIG
3.4.2 INIT
3.4.3 BACKUP
3.4.4 SHOW-SERVERS
3.4.5 SHOW-BACKUPS
3.4.6 VERIFY-CHKSUM
3.4.7 MANAGE
3.4.8 RESTORE
3.4.9 DELETE
3.5 Running the BART WAL Scanner
4 Using Tablespaces
5 Sample BART System with Local and Remote Database Servers
5.1 BART Configuration File
5.2 Establishing SSH/SCP Password-Less Connections
5.2.1 Generating a Public Key File for the BART User Account
5.2.2 Configuring Access between Local Advanced Server and the BART Host
5.2.3 Configuring Access from Remote Advanced Server to BART Host
5.2.4 Configuring Access from BART Host to Remote Advanced Server
5.2.5 Configuring Access from Remote PostgreSQL to BART Host
5.2.6 Configuring Access from the BART Host to Remote PostgreSQL
5.3 Configuring a Replication Database User
5.4 WAL Archiving Configuration Parameters
5.5 Creating the BART Backup Catalog (backup_path)
5.6 Starting the Database Servers with WAL Archiving
5.7 Taking a Full Backup
5.8 Using Point-In-Time Recovery
6. Recent Remediations
Table of Contents Previous Next