PowerProtect Database Application Agent 19.13 Installation and Administration Guide

Performing PostgreSQL transaction log backups with the ddbmoappbackup command

You can set up the backups of PostgreSQL transaction logs by registering the ddbmoappbackup command.

1. Log in to the PostgreSQL server host as the PostgreSQL operating system user.
2. To enable the PostgreSQL transaction log backups (WAL segment file archiving), register the ddbmoappbackup command with the required command line options by completing the archive_command setting in the postgresql.conf file.

   For example, complete the following setting in the postgresql.conf file:

   archive_command = '/opt/dpsapps/dbappagent/bin/ddbmoappbackup -o pg_p_opt="%p" -o pg_f_opt="%f" -l txnlog -z configuration_file_path'

   Registering the PostgreSQL archive command provides details on the archive_command setting.

   The PostgreSQL server runs the transaction log backup. By default, the server starts the backup when the WAL segment file is full. If you want the WAL segment file to be backed up more regularly, you can change the PostgreSQL setting to force a switch to a new WAL segment file and the backup to start based on your setting.