Veritas NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.1)
  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
    5.  
      NetBackup for PostgreSQL Agent Documentation
  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. The NetBackup for PostgreSQL backups and restores
    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 PostgreSQLrestores
    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 commands

This section describes the commands, options, and parameters that are available to run the nbpgsql operations. Each command contains a brief description, required parameters, and optional parameters for the respective operations. The NetBackup for PostgreSQL Agent supports only those commands, options, and parameters that are mentioned in this document.

Observe for the following:

  • Specify the parameters in the nbpgsql.conf file or provide them on the command line.

  • The parameter on the command line take precedence over the nbpgsql.conf file.

  • Specify the operation type -o on the nbmysql command line.

  • Specify the parameters and options for the respective operations in the nbpgsql.conf file or on the command line.

The NetBackup for PostgreSQL Agent command options

Table: The nbpgsql command options

Options

Description

-C

Configures the NetBackup client name for redirected restores.

-h

Displays the Help usage, when it is the only option on the nbpgsql command line.

-id

Configures the specified backup.

-l

(Linux) Configures the PostgreSQL library path.

-o

Configures the operation type (backup, restore, query, and delete).

-P

Configures the DataStore policy.

-portnum

Configures the database server port number that identifies the PostgreSQL instance on which the backup or restore is performed.

-s

Configures the NetBackup schedule.

-S

Configures the NetBackup master server.

-t

Configures the target directory to restore the data.

-u

Configures the database user name.

-z

Configures the LVM snapshot size.