Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 11.4.5 - 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.
3
Continue with the restore procedure as explained in Finalizing and submitting the job.
4
After restoring the configuration files, restart the PostgreSQL Server to apply the settings.
 
* 
IMPORTANT: You can restore configuration files when the database server is not running. However, do not include database, table, and Global Objects in the same job. If you attempt to restore any of these items together with the configuration files when the database server is not running, the restore job fails as a result of login failure.

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.
For more information, see Selecting data for a restore.
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.
You can enter the name of an existing database to restore the selected tables to this database.
 
* 
IMPORTANT: If the cluster is configured to use UTF-8 encoding at initdb, you cannot use a name that contains non-ASCII characters.
5
Click Ok.
The database item is accompanied by renaming information in parentheses.
6
Continue with the restore procedure as explained in Setting restore options and Finalizing and submitting the job.

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.
1
Select the data to restore 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 and completing the following parameter:
Specify the name of the database cluster to which the selected database is to be restored using the Database Cluster Name box in the Restore Target Details section.
3
Complete the procedure by following the instructions outlined in Finalizing and submitting the job.
 
* 
IMPORTANT: You can also rename a database while performing this type of restore. For more information, see Renaming a database during restore.

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.
 
* 
IMPORTANT: If you are not restoring from a Full Database Cluster backup, restore the Global Objects first.
1
Select the database to be restored 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.
In addition, specify the name of the database cluster to which the selected database is to be restored using the Database Cluster Name box in the Restore Target Details section.
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.
Assign a descriptive name that lets you easily identify the job when monitoring its progress. The job name can contain alphanumeric and nonalphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
 
* 
IMPORTANT: Do not use special characters that are not supported in a filename on the target OS. For example, do not use the characters /,\,*, or @ on Windows. This requirement is because Plug‑in for PostgreSQL tries to create a folder with the same name as the job title for restoring data temporarily.
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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating