Postgres

Postgres Server Backup

When the Zmanda Client for Windows is configured and licensed for Postgres backup, the ZMC allows you to select a Postgres server to back up. When a Postgres 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).

Requirements for Postgres Server Backup and Restore

These instructions assume you have already installed and licensed the Amanda Enterprise server and the Postgres server being backed up. There are a number of additional requirements:

• Make sure that your versions of Postgres conform to the tested platforms listed on the Zmanda Network Supported Platforms page.

Configuring Postgres Server Backups from the ZMC Backup What Page

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:

Host Name

The name of the machine running the Microsoft SQL server you intend to back up.

Data Directory

Check the box to compress backup images before transfer to the Amanda backup server.Host Name

The name of the machine running the Microsoft SQL server you intend to back up.

Encryption and Compression

Check the box to compress backup images before transfer to the Amanda backup server. 

Advanced Options - Estimate 

Because Postgres itself provides no completely reliable method, you can choose to have the Amanda server calculate the size (Usually Accurate) or, if databases being backed up do not change in size that much from backup to backup, just use the average size calculated from previous backups. In most cases, the default of Usually Accurate is appropriate.

After you have set the options, click the Add button to add the Microsoft SQL Postgres server to the backup set. Click Apply 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.

Configuring Postgres Server Restores from the ZMC Restore What Page

Make sure that Postgres 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.

Troubleshooting

[Need troubleshooting steps]