Chat now with support
Chat with Support

NetVault Plug-in for PostgreSQL 12.3 - User Guide

Introducing NetVault Backup Plug-in for PostgreSQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Troubleshooting

Reconfiguring 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.
4
Click the applicable database-cluster node, and select Configure from the context menu.
The Configure dialog box is displayed with all previous settings revealed, allowing you to make any necessary modifications.
5
On the Configure Database Cluster dialog box, update the parameters as required.
For more information, see Adding a database cluster.
Note the following:
•
You cannot change the Database Cluster Name.
•
The password field appears blank. If the previously configured password is still valid, you do not have to re-enter the password; the plug-in uses the cached (old) password for authentication when this field is blank. Otherwise, enter the correct password in this field.
6
To save the settings, click Ok.
 
* 
IMPORTANT: If the password for the configured superuser is changed in the PostgreSQL database, update the password in the plug-in.

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.
4
Click the applicable database-cluster node, and select Remove from the context menu.
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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating