5.5 Creating the BART Backup Catalog (backup_path)

Create the directory specified by the backup_path configuration parameter.

[BART]

bart_host= enterprisedb@192.168.2.22

backup_path = /opt/backup

pg_basebackup_path = /usr/edb/as11/bin/pg_basebackup

retention_policy = 6 BACKUPS

logfile = /tmp/bart.log

scanner_logfile = /tmp/bart_scanner.log

Make sure it is owned by the BART user account:

[root@localhost opt]# pwd

/opt

[root@localhost opt]# mkdir backup

[root@localhost opt]# chown enterprisedb backup

[root@localhost opt]# chgrp enterprisedb backup

[root@localhost opt]# chmod 700 backup

[root@localhost opt]# ls -l | grep backup

drwx------ 2 enterprisedb enterprisedb 4096 Apr 23 15:36 backup

Use the BART INIT subcommand to complete the directory structure and set the Postgres archive_command configuration parameter.

Note:

•	Before invoking any BART subcommands, set up a profile under the BART user account’s home directory to set the LD_LIBRARY_PATH and PATH environment variables. See Step 3 in Configuring the BART host section of EDB Postgres Backup and Recovery Installation and Upgrade Guide for information.

•	The -o option is specified with the INIT subcommand to force the setting of the Postgres archive_command configuration parameter when archive_mode is off or if the Postgres archive_command parameter is already set and needs to be overridden.

[user@localhost ~]$ su - enterprisedb

Password:

-bash-4.1$ bart INIT -o

INFO: setting archive_command for server 'acctg'

WARNING: archive_command is set. server restart is required

INFO: setting archive_command for server 'hr'

WARNING: archive_command is set. server restart is required

INFO: setting archive_command for server 'mktg'

WARNING: archive_command is set. server restart is required

The BART SHOW-SERVERS subcommand displays the following:

-bash-4.1$ bart SHOW-SERVERS

SERVER NAME : acctg

BACKUP FRIENDLY NAME: acctg_%year-%month-%dayT%hour:%minute

HOST NAME : 127.0.0.1

USER NAME : enterprisedb

PORT : 5444

REMOTE HOST :

RETENTION POLICY : 6 Backups

DISK UTILIZATION : 0.00 bytes

NUMBER OF ARCHIVES : 0

ARCHIVE PATH : /opt/backup/acctg/archived_wals

ARCHIVE COMMAND : (disabled)

XLOG METHOD : fetch

WAL COMPRESSION : disabled

TABLESPACE PATH(s) :

INCREMENTAL BACKUP : DISABLED

DESCRIPTION : "Accounting"

 

SERVER NAME : hr

BACKUP FRIENDLY NAME: hr_%year-%month-%dayT%hour:%minute

HOST NAME : 192.168.2.24

USER NAME : postgres

PORT : 5432

REMOTE HOST : postgres@192.168.2.24

RETENTION POLICY : 6 Backups

DISK UTILIZATION : 0.00 bytes

NUMBER OF ARCHIVES : 0

ARCHIVE PATH : /opt/backup/hr/archived_wals

ARCHIVE COMMAND : (disabled)

XLOG METHOD : fetch

WAL COMPRESSION : disabled

TABLESPACE PATH(s) :

INCREMENTAL BACKUP : DISABLED

DESCRIPTION : "Human Resources"

 

SERVER NAME : mktg

BACKUP FRIENDLY NAME: mktg_%year-%month-%dayT%hour:%minute

HOST NAME : 192.168.2.24

USER NAME : repuser

PORT : 5444

REMOTE HOST : enterprisedb@192.168.2.24

RETENTION POLICY : 6 Backups

DISK UTILIZATION : 0.00 bytes

NUMBER OF ARCHIVES : 0

ARCHIVE PATH : /opt/backup/mktg/archived_wals

ARCHIVE COMMAND : (disabled)

XLOG METHOD : fetch

WAL COMPRESSION : disabled

TABLESPACE PATH(s) :

INCREMENTAL BACKUP : DISABLED

DESCRIPTION : "Marketing"

 

-bash-4.1$ cd /opt/backup

-bash-4.1$ pwd

/opt/backup

-bash-4.1$ ls -l

total 12

drwxrwxr-x 3 enterprisedb enterprisedb 4096 Mar 29 13:16 acctg

drwxrwxr-x 3 enterprisedb enterprisedb 4096 Mar 29 13:16 hr

drwxrwxr-x 3 enterprisedb enterprisedb 4096 Mar 29 13:16 mktg

-bash-4.1$ ls -l acctg

total 4

drwxrwxr-x 2 enterprisedb enterprisedb 4096 Mar 29 13:16 archived_wals

-bash-4.1$ ls -l hr

total 4

drwxrwxr-x 2 enterprisedb enterprisedb 4096 Mar 29 13:16 archived_wals

-bash-4.1$ ls -l mktg

total 4

drwxrwxr-x 2 enterprisedb enterprisedb 4096 Mar 29 13:16 archived_wals

Note: The ARCHIVE PATH field displays the full directory path to where the WAL files are copied. This directory path must match the directory path specified in the Postgres archive_command parameter of the postgresql.conf file or the postgresql.auto.conf file of each database server.