Postgres

Version as of 08:35, 15 May 2024

to this version.

Return to Version archive.

View current version

Postgres Server Backup

When the Zmanda Client for Windows is configured and licensed for Postgres backup, it [describe backup mechanism here].

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:

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:

[insert screenshot here]

Host Name
The name of the machine running the Microsoft SQL server you intend to back up.
Compression
Check the box to compress backup images before transfer to the Amanda backup server.

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]

Troubleshooting Restores