Chatee ahora con Soporte
Chat con el soporte

NetVault Plug-in for PostgreSQL 12.3.1 - 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.
3
Open the Plug‑in for PostgreSQL node.
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.
You cannot change the Database Cluster Name.

Removing an added database cluster

1
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
3
Open the Plug‑in for PostgreSQL node.
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.

Configuring default settings

The plug-in lets you set default options for backup and restore jobs.

1
Allow File Level Data Copy Recovery to Modify postgresql.conf file. Selecting this option gives NetVault Backup permission to automatically copy the contents of the “recovery.signal” file into the “postgresql.conf” file before it begins the recovery. This option applies to Plug‑in for PostgreSQL File Level Data Copy restore and recovery jobs. By default, the option is not selected. To automate File Level Data Copy recovery, select this option. If not selected, then during a recovery, you must manually add the contents of the “recovery.signal” file to the PostgreSQL “postgresql.conf” file.

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.

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.
Allow File Level Data Copy Recovery to Modify postgresql.conf file. Selecting this option gives NetVault Backup permission to automatically copy the contents of “recovery.signal” into the “postgresql.conf” file before it begins the recovery.
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.
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación