Command Line Interface - Restore - PostgreSQL iDataAgent
In order to run the restores from command line, you need an input xml file which contains the parameter values for configuring the restore options. This input xml file can be obtained by generating the script from the CommCell Console and saving it on the computer from where the restore will be performed.
Follow the steps given below to generate a script which you can use to perform a restore from the command line interface:
- From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
- Right-click the <BackupSet> and then click All Tasks | Browse and Restore.
- Click View Content.
- In the right pane of the Browse window, select the data that you want to restore and click Recover All Selected.
- Select the required restore options which you want to execute using the script.
- Click Save as Script.
- Enter the location to save the script along with the file name and extension. For example, "C:\scripts\myscript.bat" on Windows and "/usr/scripts/myscript.sh" on Unix. Alternatively, you can also click Browse and navigate to the location.
The script will be saved as a .xml file and .bat/.sh file.
If a file with the same name already exists in the specified location, both the .xml and .bat/.sh files will be overwritten.
- Enter the username and password for the user account which you want to use to perform the restore.
By default, the user account which you have used to login to CommCell console is used for performing the restore. However, if the user account does not have access to application and database, click Use a different account.
- Click OK.
- From Command prompt, navigate to <Software_Installation_Directory>/Base and run the following command:
qlogin -cs <commserve name> -u <user name>
- Navigate to the location where the .xml file is saved and execute the saved .xml script using the qoperation execute command.
qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName xxxxx -backupsetName xxxxx -instanceName xxxxx -destPath 'xxxxx' -sourceItem 'xxxxx'
Note: If the sourceItem parameter contains a directory path, verify the path is valid before you run the command.
- Verify the status of the job using the following command:
qlist job −j jobID
- Once the job completes, log off from the CommServe using the qlogout command.
qlogout [−cs <commserve_host_name>] [−all] [−tf <tokenfile>] [−tk <token>] [−h]
|Restoring from a Current Backup||
qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName client1 -backupsetName DumpBasedBackupSet -instanceName instance1 -destPath '/etc4' -sourceItem '/etc'
|Restoring Files to a Point-in-Time (Date)||
qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName client1 -backupsetName FsBasedBackupSet -instanceName instance1 -destPath '/etc4' -sourceItem '/etc' -toTimeValue 2011-11-28
|Restoring Files to a Point-in-Time (Date and Time)||
qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName client1 -backupsetName FsBasedBackupSet -instanceName instance1 -destPath '/etc4' -sourceItem '/etc' -toTimeValue '2011-11-28 15:40:00'