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.
3
Following the steps outlined in Setting backup options, select Global Objects Only in the Backup Type section.
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.

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:

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.

Restoring data

Selecting data for a restore

1
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for PostgreSQL from the Plugin Type list.
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.

SQL FULL DB CLUSTER ARCHIVE

SQL FULL DB CLUSTER PLAIN

SQL INDIVIDUAL ARCHIVE

SQL INDIVIDUAL PLAIN

SQL GLOBAL OBJECTS ONLY

5
Click Next.
6
On the Create Selection Set page, select the data that you want to restore.
Full Database Cluster: The following nodes are displayed for this type:
Configuration Files, if included in the backup
Individual Database Cluster: The following nodes are displayed for this type:
Configuration Files, if included in the backup
Related Documents