Veritas NetBackup™ for PostgreSQL Administrator's Guide
- Introduction to NetBackup for PostgreSQL
- Installing the NetBackup for PostgreSQL Agent
- Configuring NetBackup for PostgreSQL
- NetBackup for PostgreSQL backup and restore
- About PostgreSQL backups
- Troubleshooting for PostgreSQL
- Appendix A. NetBackup for PostgreSQL commands and conventions
- Appendix B. NetBackup for PostgreSQL commands
About NetBackup for PostgreSQL Agent
NetBackup for PostgreSQL Agent extends the capabilities of NetBackup to include backup and restore of the PostgreSQL databases. The NetBackup for PostgreSQL Agent is located on the NetBackup client and supports the operations on standalone setups. The agent supports the PostgreSQL version 9 and later.
The agent also supports to:
Validate the backup.
Query a backup and restore.
Delete the backup information from the catalog files.
Redirect restores.
Note:
Ensure that the PostgreSQL agent and NetBackup are of same version for successful backup and restore operations.
The NetBackup for PostgreSQL Agent reads the parameters from the nbpgsql.conf
file and initiates the operation. The nbpgsql.conf
file contains the parameters that you must set for the nbpgsql command to run the respective operations.
The agent communicates with the PostgreSQL database to create a snapshot. The Volume Shadow Copy Services (VSS) for Windows or Logical Volume Manager (LVM) for Linux, takes a snapshot of the PostgreSQL database.
The agent then interacts with the NetBackup XBSA interface to update the server name, policy, and schedule type information. The NetBackup master server connects to the NetBackup client to backup or retrieve the data that you want to protect.
The agent mounts the snapshot, copies the file, and sends it to the NetBackup XBSA interface. The NetBackup XBSA interface writes this data to the mounted media or disk storage that is managed by the NetBackup media server.
Table: NetBackup for PostgreSQL configuration files lists the configuration files. These files contain the parameters that you must specify for the respective operations.
Table: NetBackup for PostgreSQL configuration files
Component | Description |
---|---|
| The For more information, See The nbpgsql.conf configuration file. |
| The For more information, See Recovering the restores. |
| The For more information,See About PostgreSQL backups. |
| The For more information, See Authenticating the password . |
| The For more information, See Authenticating the password . |
Note:
You must set the parameters in the nbpgsql.conf
file before you run the operations or provide them on the nbpgsql command line, where command line parameters take precedence.