When the Zmanda Client for Windows is configured and licensed for PostgreSQL backup, the ZMC allows you to select a PostgreSQL server to back up. When a PostgreSQL server is backed up, all databases are included in the backup, which can be either full (using pg_dump) or incremental (which depends on Posgres write-ahead logs, referred to as WALs).
These instructions assume you have already installed and licensed the Amanda Enterprise server and the PostgreSQL server being backed up. There are a number of additional requirements:
property "PG_DATA" "Path_to_PSQL_Data_Dir"
property "PG_ARCHIVE" "Path_to_PSQL_Archive_Dir"
property "PG_HOST" "localhost_or_path_to_socket_file"
property "PG_TMP" "Path_to_temp_dir"
property "PSQL" "Path_to_PSQL_Binary"
Path_to_PSQL_Data_Dir
Create a dedicated backup set for each Postres server you intend to back up. On the Backup What page you are prompted to select what type of object you want to back up. Choose Postgres, and the following options are displayed:
After you have set the options, click the Add button to add the PostgreSQL server to the backup set. Click Apply Plan to Server to commit the changes; you can then configure the backup set just as you would any other by setting the options on Backup Where, Backup How, and Backup When, etc.
Make sure that PostgreSQL is installed in the same location as when the backup was run. The databases and logs file locations should also match the original configuration. When you have selected the disk list entry that includes the Postgres server for restore, the Restore What page displays the following options:
[insert screenshot]
Select all the appropriate options and Restore->What page.
[Need troubleshooting steps]