Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 11.1 - User Guide

Removing an added database cluster

1
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
2
In the selection tree, open the applicable client node.
3
Open the Plug‑in for PostgreSQL node, and select the applicable database-cluster node.
4
From the Actions list, select Remove.
5
In the confirmation dialog box that is displayed, click OK.
* 
IMPORTANT: The Plug‑in for PostgreSQL node will remain in an Open state even after the last database cluster is removed. To close this node and access the other plug-ins in the selection tree, double-click the plug-in node.

Setting default actions for error conditions (optional)

The plug-in lets you set default options for backup and restore jobs. You can override these options on a per job basis.

1
In the Navigation pane, click Change Settings.
2
On the Configuration page, click Server Settings or Client Settings, as applicable.
3
If you selected Client Settings, select the applicable client, and click Next.
4
On the NetVault Server Settings or Client Settings page, click Plugin Options.
In the Plug‑in for PostgreSQL section, the following items are listed:
•
Manually Selected Database Unavailable: This issue occurs when an individual database that was manually selected, that is, explicitly clicked, for inclusion in the backup is unavailable for backup. The database might be unavailable for any reason, such as being dropped since the backup job was defined.
•
Manually Selected Table Unavailable: This issue occurs when an individual table that was manually selected, that is, explicitly clicked, for inclusion in the backup is unavailable for backup. The table might be unavailable for any reason, such as being dropped since the backup job was defined.
•
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.
5
For each of these conditions, select one of the following settings:
•
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.
6
To save the settings, click Apply.

Backing up data

•
Defining a backup strategy
•
Performing a backup
•
Backing up Global Objects only
•
Backing up configuration files
* 
IMPORTANT: On Windows, use appropriate encoding during database cluster initialization; that is, when you run initdb. Backups fail if you use UTF-8 encoding and the database or table names contain non-ASCII characters.

Defining a backup strategy

Before commencing with database backups, ensure that you have a backup strategy that safeguards data against media failure, data corruption, user error, and loss of the database server. The following topics provide information that helps you devise a backup strategy for use with Plug‑in for PostgreSQL.

•
Supported backup formats
•
Available backup types
•
Backup strategy considerations
•
Examples of backup sequences
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating