Configuring the New Tool

This section draws a comparison between the three tools and shows how they differ in configuration (config file), and in scheduling. During a migration it is important to be aware of all of these differences, and apply changes as necessary.

How Features are Configured

The following sections describes how to enable features in the different tools so you can easily compare the implementation details .

Postgres connection details

Tool

Configuration

BART

In the [SERVER] section of the config file: [ example]…host = localhostuser = postgres port = 5432

Barman

In the config file: [example]…con ninfo = host=localhost user=postgres dbname=postgres

pg BackRest[^*]

In the config file: [example]…p g1-host = localhostpg1-path = /var/lib/postgre s/datapg1-user = postgresport = 5432

Specify pg1-path when pgBackRest is running locally, and specify pg1-host when pgBackRest is running remote

Use of direct file copy mode (ssh or rsync) instead of pg_basebackup

Tool

Configuration

BART

Increase threads >1 in the [SERVER] or [BART] section of the config file:[example]…thread_count = 2Or, as a commandline option --no-pg_basebackup

Barman

In the config file: [example]…backup_method = rsync

p gBackRest

pgBackRest does not support pg_basebackup option

Incremental backups

Tool

Configuration

BART

Retrieve the backup_id or backup_name for the parent:bart SHOW-BACKUPS exampleNow supply he backup_id or backup_name as parent:bart B ACKUP –s example --parent { backup_id \| backup_name }

Barman

In the config file:[example]…reuse_backup = linkOr, as a command line option:--reuse-backup=link

p gBackRest

pgbackrest --stanza=example --type=incr backup

WAL archive compression**

Tool

Configuration

BART

In the [SERVER] or [BART] section of the config file: [example]…wal_compression = enabled

Barman

In the config file:[example]…compression = gzip

p gBackRest

Global compress settings. Can be overloaded for [global:archive-push]

Backup compression

Tool

Configuration

BART

Command line option: Enable: --gzipLevel: --compress-level

Barman

N/A

p gBackRest

compress=ycompress-level=9 compress-type=gzcompress-level-network=3

Parallel backup and restore

Tool

Configuration

BART

Set thread_cound in the [SERVER] or [BART] section of the config file: [example]…thread_count = 4Or, as a Command line option --thread-count=4

Barman

Set parallel_jobs in the configfile:[example]…parallel_jobs = 4Or, as a command line option --jobs 4

p gBackRest

Set process-max in the configfile:[example]…process-max = 4Or, as a command line option --process-max=4

Retention Policy

Tool

Configuration

BART

Set retention_policy in the [SERVER] or [BART] section of the config file:[example]…retention_policy = 2 BACKUPS # Or DAYS, WEEKS, or MONTHS

Barman

Set retention_policy, and/or wal_retention_policy options in the config file:[example]…retention_policy =REDUNDANCY 2 ``\ or\ ``retention_policy = RECOVERY WINDOW OF 2 DAYS # WEEKS/MONTHS.

p gBackRest

Can be set in the config file:[example ]…repo-retention-full-type = count #can also be time ``\ \ ``repo-retention-full = 2repo-retention-di ff = 6# Retain WAL archives for only 1 full back up:repo-retention-archive-type = full #can also be diff or incrrepo-retention-archive = 1See Retention Policy in edb documentation for more information.

Configure repository location

Tool

Configuration

BART

In the config file in the [BART] section:[BART]…backup_path = /tmp/bart

Barman

In the config file in the main chapter:backup_directory = /tmp/barman

p gBackRest

[global]repo1-path=/var/lib/pgbackrest