Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 11.1 - User Guide

Restoring configuration files

When restoring configuration files, you do not have to set any restore options — unless you are restoring to a different cluster or server; for more information, see Restoring data to a different database cluster. The plug-in does not let you select individual configuration files for restoration.

1
Select the Configuration Files node from the backup saveset by following the instructions outlined in Selecting data for a restore.
2
Set the Restore Options by following the instructions outlined in Setting restore options.

Renaming a database during restore

Renaming a database can be useful if you do not want to overwrite the existing version and want to create a copy of the database.

1
In the Navigation pane, click Create Restore Job, select Plug‑in for PostgreSQL from the Plugin Type list, select the applicable saveset, and click Next.
2
On the Create Selection Set page, select the database that you want to rename.
3
From the Actions list, select Rename.
4
In the Rename/Relocate dialog box, enter the new name in the Rename to box.
IMPORTANT: If the cluster is configured to use UTF-8 encoding at initdb, you cannot use a name that contains non-ASCII characters.
5

Restoring data to a different database cluster

You can restore a database to a different database cluster running on the database server. The following topics outline the procedure for performing this type of a restore.

Before initiating this type of restore, verify that the following prerequisites are met:

Same version of PostgreSQL installed: The PostgreSQL version must be same as the version running on the existing database server.
Database cluster exists on the PostgreSQL Server: A database cluster must exist on the PostgreSQL Server and this cluster must be added to the plug-in. To add the cluster, see Adding a database cluster.
2
Set the Restore Options by following the instructions outlined in Setting restore options and completing the following parameter:

Restoring to a database cluster on an alternate server

You can restore a database cluster to a different PostgreSQL Server. Before initiating this type of restore, verify that the following prerequisites are met on the new restore target:

Same OS: The OS running on the target system must be same as the source system.
Same version of PostgreSQL installed: The PostgreSQL version must be same as the version running on the existing database server.
NetVault Backup software and Plug‑in for PostgreSQL installed: The same version of NetVault Backup software and the plug-in must be installed and configured on the new restore target.
Client added to the NetVault Backup Server: The target machine must be added to the NetVault Backup Server through the NetVault Backup WebUI.
Database cluster exists on the new restore target: A database cluster must exist on the new restore target and the cluster must be added to the plug-in. To add the cluster, see Adding a database cluster.
2
Set the Restore Options by following the instructions outlined in Setting restore options.
3
To save the settings, click Ok, and then click Next.
4
In Job Name, specify a name for the job if you do not want to use the default setting.
5
In the Target Client list, select the new restore target.
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.
6
Use the Schedule and Advanced Options lists to configure any additional required options.
7
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.
Related Documents