PowerProtect Database Application Agent 19.15 Installation and Administration Guide

Database application agent features specific to PostgreSQL

The database application agent supports the backups and restores of PostgreSQL database data to and from a DD Boost device through the Orchestrated Application Protection feature.

The database application agent program ddbmoappbackup works with the PostgreSQL utilities pg_dump and pg_dumpall to perform the database full backups without WAL (write ahead log) segment file archiving. The ddbmoappbackup program requires the pg_basebackup utility to perform the database full backups if the WAL segment file archiving is enabled. The ddbmoappbackup program also performs the transaction log backups. After you complete the required backup configuration, you can perform manual database application agent backups of the PostgreSQL data.

The database application agent program ddbmoapprecover retrieves the PostgreSQL data backup into a user-specified directory. The directory does not initially exist on the file system, and the program creates the directory. The ddbmoapprecover program also can retrieve the archived WAL segment file to the required location. After you run the ddbmoapprecover program, you must run the required PostgreSQL restore utility to complete the restore of the data backup.

Orchestrated Application Protection overview provides more details about Orchestrated Application Protection.