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 the following clients:
-
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.
Number of Streams
Enter the number of streams to use in the restore operation.
Cleanup old directories
Select this check box to clean up data, tablespace, and archive log directories before performing the restore operation.
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.
Custom start command
Enter a command of your choice to start the PostgreSQL Server.
Note
If you leave the Custom start command box empty, the Commvault software uses the pg_ctl command to start the PostgreSQL Server.
Point In Time
Specifies that the restore operation must restore single or multiple databases to the selected date and 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.
Advanced
Click to select additional restore options.
Save As Script
Click to open the Save As Script dialog box, which allows you to save this operation and the selected options as a script file (in XML format). The script can later be run from the Command Line Interface using qoperation execute command.
When you save an operation as a script, each option in the dialog box has a corresponding XML element in the script file. When you run the script, you can modify the value in any of these XML elements.
For more information on restores performed from the command line, see Command Line Interface for PostgreSQL iDataAgent.