Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 11.1 - User Guide

Performing a backup

A backup using Plug‑in for PostgreSQL includes the steps outlined in the following topics.

Selecting data for a backup

You must use sets — Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set — to create a backup job. For more information, see the Quest NetVault Backup Administrator’s Guide.

TIP: To use an existing set, click Create Backup Job, and select the set from the Selections list.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
3
Next to the Selections list, click Create New.
4
In the list of plug-ins, open Plug‑in for PostgreSQL.
The plug-in attempts to connect to the database server with the name and password specified in the Configure dialog box. After successful authentication, the added database clusters are displayed.
To make Full Database Cluster backups, do one of the following:
To back up all the databases, including Template Databases, and the configuration files contained in the cluster, select the database-cluster node.
To back up only the databases, including Template Databases, select the All Databases node, or clear the Configuration Files node after selecting the database-cluster node.
Open the All Databases node, and select the required databases. To include Template Databases in the backup, select the node, for example, template1.
6
Click Save, enter a name in the Create New Set dialog box, and click Save.

Setting backup options

The next step involves creating the Backup Options Set or selecting an existing one.

TIP: To use an existing set, in the Plugin Options list, select the set that you want to use.
1
Next to the Plugin Options list, click Create New.
2
In the Backup Type section, select the applicable option:
3
In the Backup Format section, select the applicable option:
IMPORTANT: NetVault Backup limitation on Windows: NetVault Backup resets the selection in Backup Format to the default (Plain Text SQL Script) if you change the Backup Type after selecting the file format. To avoid this issue, select the applicable Backup Format explicitly after selecting the Backup Type.

A similar problem also occurs when you save a Backup Options set. NetVault Backup resets the Backup Format to the default after you click OK. However, the saved Backup Options set contains your actual selection. Similarly, when you try to load a Backup Options set, the Plain Text SQL Script format is displayed as selected, which is incorrect. Internally, the plug-in uses the actual selected Backup Format.
4
If you selected a Backup Format of Plain-Text SQL Script File, select the applicable Backup Options:
Include Data Only (No Schema Definitions): To back up only the data without the schema, select this option. Data-only restores can only be performed for backups performed with this option selected.
IMPORTANT: Template Databases are not included if you select this option.
Disable Triggers: This option is only relevant when creating a data-only dump. Select this option if there are referential integrity checks or other triggers on the tables. This option temporarily disables triggers on the target tables during restore. After a successful restore, the triggers are enabled.
Include BLOBs: To back up binary large objects (BLOBs), select this option. When this option is selected, all BLOBs within the selected database are backed up regardless of whether the associated table is included.
Include Object Identifiers: This option dumps object identifiers (OIDs) as part of the data for every table. Use this option if the OID columns are referenced, for example, in a foreign key constraint. Otherwise, do not select this option.
Include Drop Object Commands: To drop and re-create objects during the restore process, select this option.
Exclude Access Privileges: To prevent dumping of access privileges, grant and revoke commands, select this option.
Disable $ Quoting for Function Bodies: To disable the use of dollar quoting for function bodies and force them to be quoted using SQL-standard string syntax, select this option.
Dump Data as Copy Data: To dump data using COPY commands instead of INSERT commands during a restore, select this option. Dumping data as INSERT commands generates a separate command for each row of data. This method is safer because any errors that occur result only in the loss of a row of data instead of losing the whole table. Dumping data as COPY commands might result in the loss of the whole table if an error occurs in one of the rows of data.
5
If you selected a Backup Format of TAR Archive File, select the applicable Backup Options:
Include BLOBs: To back up BLOBs, select this option. When this option is selected, all BLOBs within the selected database are backed up regardless of whether the associated table is included.
Disable $ Quoting for Function Bodies: To disable the use of dollar quoting for function bodies and force them to be quoted using SQL-standard string syntax, select this option.
Dump Data as Copy Data: To dump data using COPY commands instead of INSERT commands during a restore, select this option. Dumping data as INSERT commands generates a separate command for each row of data. This method is safer because any errors that occur result only in the loss of a row of data instead of losing the whole table. Dumping data as COPY commands might result in the loss of the whole table if an error occurs in one of the rows of data.
6
If you selected a Backup Format of Custom Archive File, select the applicable Backup Options:
Include BLOBs: To back up BLOBs, select this option. When this option is selected, all BLOBs within the selected database are backed up regardless of whether the associated table is included.
Disable $ Quoting for Function Bodies: To disable the use of dollar quoting for function bodies and force them to be quoted using SQL-standard string syntax, select this option.
Compression Level: Set the compression level between 0 and 9 to use for the custom archive format.
For a Full Database Cluster backup, the action can be set for the following scenario: Failed to Backup Configuration Files. This issue occurs when a configuration file is not found or cannot be backed up for any other reason. The “pg_hba.conf” file is used for user authentication; if this file is missing during job execution, the backup fails because of login failure, regardless of the action set for the Failed to Backup Configuration Files error condition.
For an Individual Database/Table backup, the action can be set for the following additional scenarios:
Manually Selected Database Unavailable: This issue occurs when an individual database that was manually selected for inclusion in the backup is unavailable for backup for any reason.
Manually Selected Table Unavailable: This issue occurs when an individual table that was manually selected for inclusion in the backup is unavailable for backup for any reason.
Complete with Warnings — Saveset Retained: The job returns a status of “Backup Completed with warnings” and a backup saveset is created that includes the items that were successfully backed up.
Complete without Warnings — Saveset Retained: The job completes and returns a status of “Backup Completed.” The errors are logged in the NetVault Backup binary logs and ignored on the Job Status page. A backup saveset is created that includes the items that were backed up.
Fail — Saveset Retained: The job returns a status of “Backup Failed.” However, a backup saveset is generated that includes the items that were successfully backed up.
Fail — No Saveset Retained: The job returns a status of “Backup Failed” and no saveset of backed-up objects is kept. That is, even if some of the objects were successfully backed up, the saveset is discarded.
8
Click Save.
9
In the Create New Set dialog box, specify a name for the set, and click Save.

Finalizing and submitting the job

1
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
2
Click Save or Save & Submit, whichever is applicable.
TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now.
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