Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 11.1 - User Guide

Backing up Global Objects only

You can back up Global Objects in two ways:

•
By using the Full Database Cluster backup type: A Full Database Cluster backup performed in any format includes the Global Objects. Because these objects are cluster-wide and not specific to any individual database, backups of type Individual Database/Table do not include Global Objects.
•
By using the Global Objects Only backup type: You can also back up the Global Objects separately using the Global Objects Only backup type provided by the plug-in.

To create a Global Object Only backup, complete the following steps

1
Following the steps outlined in Selecting data for a backup, select the target database-cluster node.
2
If you want to exclude the configuration files, which are automatically selected when you select the database-cluster node, clear the Configuration Files node in the selection tree.
3
Following the steps outlined in Setting backup options, select Global Objects Only in the Backup Type section.
4
If you included the configuration files, select the required action to take if an error occurs during the backup:
•
Complete with Warnings — Saveset Retained
•
Complete without Warnings — Saveset Retained
•
Fail — Saveset Retained
•
Fail — No Saveset Retained
Because the “pg_hba.conf” file is used for user authentication, backup fails if this file is missing during job execution. This login failure causes the backup to fail regardless of the action set for the Failed to Backup Configuration Files error condition.
5
Following the steps outlined in Finalizing and submitting the job, complete and submit the job.

Backing up configuration files

You can select configuration files for backup with any of the backup types. Regardless of the format selected, the plug-in performs a file-system backup of the following files:

•
postgresql.conf
•
pg_hba.conf
•
pg_ident.conf

To back up these files separately, complete the following steps.

1
Following the steps outlined in Selecting data for a backup, select the Configuration Files node in the selection tree.
2
Because the Backup Type and Backup Format are not considered, select any of the options in Backup Options when you create the Backup Options Set by following the steps outlined in Setting backup options.
3
Following the steps outlined in Finalizing and submitting the job, complete and submit the job.

Restoring data

•
Selecting data for a restore
•
Setting restore options
•
Finalizing and submitting the job
•
Performing advanced restore procedures

Selecting data for a restore

1
In the Navigation pane, click Create Restore Job.
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for PostgreSQL from the Plugin Type list.
3
To filter the items displayed in the saveset table further, use the Client, Date, and Job ID lists.
The table displays the saveset name (job title and saveset ID), creation date and time, and size. By default, the list is sorted alphabetically by saveset name.
4
In the saveset table, select the applicable saveset to display the database cluster that was the target of the backup.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, job title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, saveset size, and snapshot-based backup or not.
The following table outlines the backup type identifiers:
Backup type identifier
Backup type and format

SQL FULL DB CLUSTER ARCHIVE
•
Full Database Cluster
•
TAR/Custom Archive File

SQL FULL DB CLUSTER PLAIN
•
Full Database Cluster
•
Plain-text SQL Script File

SQL INDIVIDUAL ARCHIVE
•
Individual Database/Table
•
TAR/Custom Archive File

SQL INDIVIDUAL PLAIN
•
Individual Database/Table
•
Plain-text SQL Script File

SQL GLOBAL OBJECTS ONLY
•
Global Objects Only
5
Click Next.
6
On the Create Selection Set page, select the data that you want to restore.
Based on the backup type, opening the database cluster displays the following:
•
Full Database Cluster: The following nodes are displayed for this type:
•
Configuration Files, if included in the backup
•
Global Objects
•
All Databases
•
Individual Database Cluster: The following nodes are displayed for this type:
•
Configuration Files, if included in the backup
•
All Databases
7
To view the databases included in the backup, open All Databases.
8
For next-level selections, drill down further.
9
Select the database cluster, databases, or tables as required.
* 
IMPORTANT: BLOBs included in the backup are displayed as a separate node, and not beneath the associated table. Selecting this node restores all BLOBs contained in the saveset and not just objects associated with the selected table. Also note that, to restore BLOBs, this node must be selected explicitly, that is, either this node or the parent database node must be selected. Selecting only the table does not restore the associated BLOBs.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating