Table of Contents Previous Next


2 Overview : 2.1 Block-Level Incremental Backup : 2.1.1 Incremental Backup Limitations and Requirements

An incremental backup cannot be taken on a standby database server; only a full backup can be taken from a standby database server.
Create or select an operating system account to be used as the BART user account. See Section 4.1 for information on choosing and setting up the BART user account.
In the BART configuration file, the cluster_owner parameter must be set to the Linux operating system user account that owns the directory of the database cluster from which incremental backups are to be taken. The allow_incremental_backups parameter must be enabled. See Section 4.2.5 for information.
A password-less SSH/SCP connection must be established between the BART user account on the BART host and the cluster_owner user account on the database server. Note: This password-less SSH/SCP connection must be established even if BART and the database server are running on the same host and the BART user account and the cluster_owner user account are the same account. See Section 4.2.1 for information.
In addition to the BART host where the BART backup catalog resides, the BART package must also be installed on every remote database server on which incremental backups are to be restored. In order to restore an incremental backup, the bart program must be executable on the remote host by the remote user specified by the remote_host parameter in the BART configuration file or by the -r option when using the RESTORE subcommand to restore the incremental backup. See Section 2.1.5.2 for information on restoring incremental backups on remote hosts.
For restoring incremental backups on a remote database server, a password-less SSH/SCP connection must be established from the BART user account on the BART host to the remote user on the remote host that is specified by the remote_host parameter in the BART configuration file or by the -r option when using the RESTORE subcommand to restore the incremental backup. See Section 2.1.5.2 for information on restoring incremental backups on remote hosts.
Compression of archived WAL files in the BART backup catalog is not permitted for database servers on which incremental backups are to be taken. The wal_compression setting in the BART configuration file must not be enabled for those database servers. Disabled is the default setting unless the parameter is altered in the global section or the server section. See sections 4.1 and 4.2.5 for information on the wal_compression parameter.

2 Overview : 2.1 Block-Level Incremental Backup : 2.1.1 Incremental Backup Limitations and Requirements

Table of Contents Previous Next