PostgreSQL Restore Options (FSBasedBackupSets)

Use this dialog box to select restore options for FSBasedBackupSets.

Destination Client/Computer/Server

Displays the name of the client computer to which the selected data will be restored. To change the destination computer, select one from the list. The list includes clients:

  • Which are established as clients within the CommCell.
  • Clients with Operating Systems that support the cross-platform restore operation from this client. (Refer to the topic titled Cross Platform Restore Operations in Books Online for additional information.)

By default, data is restored to the same computer from which it was backed up.

Source Server

Displays the name of the source server or database, depending on whether an instance or database was selected for restore.

Destination Server

Displays the name of the server to which the selected data will be restored. To change the destination, click one from the list.

Point In Time

Click to select the point in time restore for FSBasedBackupSet. The point in time option enables you to restore the database to a specific point-in-time.

Restore Time

Lists the date and time. Select the date and time to which you would like to restore the PostgreSQL server.  By default, the PostgreSQL server will be restored to the latest time when you restore an entire PostgreSQL server from the instance level. ( If you want select a restore time, then make sure to select the restore time of the last backup cycle). When you restore from backup set level (Browse and Restore), the restore time should be later than the browse time.

Time Zone

Lists the time zones. To change the time zone, select one from the list.


Click to select additional restore options.

Save As Script

Click to open the Save As Script dialog, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be executed from the Command Line Interface using qoperation execute command.

When you save an operation as a script, each option in the dialog will have a corresponding XML parameter in the script file. When executing the script, you can modify the value for any of these XML parameters as per need.

For more information on restores performed from the command line, see Command Line Interface for PostgreSQL iDataAgent.