Command Line Interface - Restore - PostgreSQL iDataAgent

Generate the Command Line Script from the CommCell Console

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.

Perform the Restore

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
```
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]

Examples

Restoring Databases from DumpBased Backupset

Restoring Schemas from DumpBased Backupset

qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName 'client1' -backupsetName 'DumpBasedBackupSet' -instanceName 'instance1' -subclientName 'default' -sourceItem '/database1/schema1/' -tableLevelRestore True

Restoring Tables from DumpBased Backupset

Restoring Databases to an Auxiliary Database from DumpBased Backupset

Restoring with 'Skip Import' Option from DumpBased Backupset

Running Out-of-Place Restore from DumpBased Backupset

Restoring Databases from FSBased Backupset

qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName 'client1' -backupsetName 'FSBasedBackupSet' -instanceName 'instance1' -sourceItem '/' -fsBackupSetRestore True

Running Out-of-Place Restore from FSBased Backupset

Running Out-of-Place Restore from FSBased Backupset Specifying Different Data and Tablespace Paths on Destination

qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName 'client1' -backupsetName 'FSBasedBackupSet' -instanceName 'instance1' -sourceItem '/' -fsBackupSetRestore True -destinationInstance/ClientName 'client2' -destinationInstance/instanceName 'destinstance' -destClient/clientName 'client2' -redirectEnabled True -redirectItems '|BACKUP_PATH1|#15!RESTORE_PATH1' -redirectItems '|BACKUP_PATH2|#15!RESTORE_PATH2'

For Instance:

qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName 'client1' -backupsetName 'FSBasedBackupSet' -instanceName 'instance1' -sourceItem '/' -fsBackupSetRestore True -destinationInstance/ClientName 'client2' -destinationInstance/instanceName 'destinstance' -destClient/clientName 'client2' -redirectEnabled True -redirectItems '|/var/lib/pgsql/13/data|#15!/tmp/data' -redirectItems '|/u01/tablespace1|#15!/tmp/tablespace1'

Where, /var/lib/pgsql/13/data is the data directory, and /u01/tablespace1 is the tablespace path.

Running Restore from FSBased Backupset without Starting the Server

Running a Point-in-Time Restore from FSBased Backupset

Running a Volume-Level Restore from FSBased Backupset

Running a Table-Level Restore from Block-Level Enabled Subclient

Running a Table-Level Restore with 'Skip Import' Option from Block-Level Enabled Subclient

Running a Database-Level Restore to an Auxiliary Database from Block-Level Enabled Subclient

qoperation execute -af restore.xml -appName 'PostgreSQL' -clientName 'client1' -backupsetName 'FSBasedBackupSet' -instanceName 'instance1' -sourceItem '/database1/public/tab1/' -fsBackupSetRestore True -tableLevelRestore True -stagingPath '/tmp' -sourceDB 'database1' -auxillaryDB 'database2' -anyAuxilaryDatabase true