Veritas NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.2)
  1. Introduction to NetBackup for PostgreSQL
    1.  
      About NetBackup for PostgreSQL Agent
    2.  
      Features supported by NetBackup for PostgreSQL Agent
    3.  
      The NetBackup for PostgreSQL Agent package
    4.  
      About the License for NetBackup for PostgreSQL Agent
  2. Installing the NetBackup for PostgreSQL Agent
    1.  
      Planning the installation of NetBackup for PostgreSQL Agent
    2.  
      Verifying the operating systems and platforms
    3.  
      Installing prerequisites for NetBackup for PostgreSQL Agent
    4.  
      Post-installation requirements for NetBackup for PostgreSQL Agent
    5.  
      Describing the NetBackup for PostgreSQL Agent package
    6.  
      Installing the NetBackup for PostgreSQL Agent
    7.  
      Authenticating the password
    8.  
      Uninstalling the NetBackup for PostgreSQL Agent
  3. Configuring NetBackup for PostgreSQL
    1.  
      The nbpgsql.conf configuration file
    2.  
      Configuring PostgreSQL backups with DataStore policies
  4. NetBackup for PostgreSQL backup and restore
    1. About PostgreSQL backups
      1.  
        The postgresql.conf configuration file
    2.  
      Performing PostgreSQL backups
    3.  
      Validating the PostgreSQL backups
    4.  
      Querying the PostgreSQL backups
    5.  
      Deleting backup information from the NetBackup catalog files
    6.  
      About PostgreSQL restore
    7.  
      Performing the PostgreSQL restores
    8.  
      Redirected restores
    9.  
      Recovering the restores
    10.  
      Disaster recovery
  5. Troubleshooting for PostgreSQL
    1.  
      Troubleshooting errors when using NetBackup for PostgreSQL Agent
  6. Appendix A. NetBackup for PostgreSQL commands and conventions
    1.  
      About NetBackup for PostgreSQL Agent commands
    2.  
      NetBackup for PostgreSQL Agent command conventions
  7. Appendix B. NetBackup for PostgreSQL commands
    1.  
      nbpgsql -o backup
    2.  
      nbpgsql -o restore
    3.  
      nbpgsql -o query
    4.  
      nbpgsql -o delete

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 workflow

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

nbpgsql.conf file

The nbpgsql.conf file contains the parameters that you must specify before you run the nbpgsql operations.

For more information, See The nbpgsql.conf configuration file.

recovery.conf file

The recovery.conf file contains the parameters that you must set for PostgreSQL to perform an archive recovery. You must set the parameters again for the subsequent recovery that you must perform.

For more information, See Recovering the restores.

postgresql.conf file

The postgresql.conf file contains the parameters that you must set to archive the Write-Ahead Logs.

For more information,See About PostgreSQL backups.

pgpass.conf file

The pgpass.conf file contains the password to connect to the database for Windows.

For more information, See Authenticating the password .

.pgpass file

The .pgpass file contains the password to connect to the PostgreSQL database for Linux operating systems.

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.