Veritas NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.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

Post-installation requirements for NetBackup for PostgreSQL Agent

After you install

  • (Windows) Configure the NetBackup for PostgreSQL Agent to run with administrative privileges.

  • (Windows) Add the NetBackup bin directory to the PATH user environment variable.

  • (Linux) If the nbpgsql.conf file does not exist, create the default configuration file. For more information, See The nbpgsql.conf configuration file.

  • (Linux) Symbolic link: If a symbolic link does not exists, create libpq.so that points to libpq.so.<n>, where <n> is the PostgreSQL library version. You can create the symbolic link at your chosen directory.

    For example, if the PostgreSQL library version is 5, then the symbolic link libpq.so points to libpq.so.5.

    Note:

    Ensure that you update the PGSQL_LIB_INSTALL_PATH parameter in the nbpgsql.conf with the absolute path of the symbolic link.

  • (Linux) The user of the agent is a superuser or has superuser privileges.

  • Set the following database user privileges:

Table: User and the privileges

User

Privileges

Backup

LOCK TABLES, SELECT FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW, VIEW, EXECUTE, and EVENT.

Restore

CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, DELETE, UPDATE, TRIGGER, SUPER, and CREATE VIEW.

To set the database user privileges, run the following PostgreSQL command:

ALTER USER<db_user> with SUPERUSER

For more information, see PostgreSQL Administrator's Guide.