PostgreSQL Database Restore Options Dialog (General)

Use this dialog box to control how the specified data is to be restored.

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 instance to which the selected data will be restored. To change the destination, click one from the list.

Recover Database Server

Specifies that the PostgreSQL Server should automatically restart after the restore operation is complete.

Clear this check box in the following two scenarios:

  • If you do not want the PostgreSQL Server to start automatically after the restore operation is complete.
  • If you are restoring an instance that has a UNC path as its Archive Log Directory. After the restore is complete, you can start the PostgreSQL Server manually.
Point in time

Specifies that the restore operation must restore single or multiple databases to the selected date and time.

Restore Time and Time Zone

Displays only those jobs that occurred within the specified point in time. Select the following options:
  • Restore Time

    Provides a space for you to enter the date and time. Click the arrow to display a calendar.

  • 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.