Skip to main content

PowerProtect Database Application Agent 19.15 Installation and Administration Guide

PDF

Registering the PostgreSQL archive command

To enable the PostgreSQL WAL backups with Orchestrated Application Protection, you must register the ddbmoappbackup program with the required command line options through the archive_command setting in the postgresql.conf file.

In the archive_command setting, specify the ddbmoappbackup command and its command line options. For example, the postgresql.conf file can include the following archive_command setting: 

archive_command = '/opt/dpsapps/dbappagent/bin/ddbmoappbackup -o pg_p_opt="%p" -o pg_f_opt="%f" -l txnlog -z configuration_file_path'
NOTE:
  • The options -o pg_p_opt="%p" -o pg_f_opt="%f" -l txnlog indicate that the operation is a PostgreSQL WAL backup.
  • The backup and restore must use the same DATABASE_TYPE, INSTANCE_NAME, and BACKUP_NAME parameter settings in the configuration file so that the restore can locate the WAL segment files that belong to the backup.

Table 1 describes the supported command line options that you can include in the archive_command setting.

NOTE:

The registered archive command will be run by the same user as the PostgreSQL server.

To enable WAL (write ahead log) archiving, set the following parameters in the postgresql.conf file:

  • Set wal_level to archive (or hot_standby).
  • Set archive_mode to on.
The PostgreSQL online documentation provides more details.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\