NetBackup™ Web UI PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (10.4)
  1. Overview
    1.  
      Overview of configuring and protecting PostgreSQL assets in the NetBackup web UI
  2. Managing PostgreSQL instances and databases
    1.  
      Quick configuration checklist to protect PostgreSQL instances and databases
    2.  
      Configure PostgreSQL instance
    3.  
      Add a PostgreSQL instance
    4.  
      Manage credentials for an instance
    5.  
      Discover PostgreSQL databases
    6.  
      Remove PostgreSQL instances
    7.  
      Change the autodiscovery frequency of PostgreSQL assets
  3. Managing PostgreSQL environment credentials
    1.  
      Add new PostgreSQL credentials
    2.  
      Default PostgreSQL Administrator
    3.  
      Validate credentials of PostgreSQL instance
    4.  
      View the credential name that is applied to an asset
    5.  
      Edit or delete a named credential
  4. Protecting PostgreSQL instances and databases
    1.  
      Things to know before you protect PostgreSQL instances and databases
    2.  
      Protect PostgreSQL instances and databases
    3.  
      Customize protection settings for the PostgreSQL assets
    4.  
      Remove protection from PostgreSQL instances
    5.  
      View the protection status of PostgreSQL instance
  5. Restoring PostgreSQL Instances and Databases
    1.  
      Things to know before you restore the PostgreSQL instances and databases
    2.  
      About the pre-restore check
    3.  
      Restore PostgreSQL instance and database
    4.  
      Restore target options
    5.  
      Pre-restore checks for PostgreSQL
    6.  
      Steps to perform recovery after restore operation
    7.  
      Steps to perform after Restore and Recovery for PostgreSQL cluster deployment
    8.  
      Limitations
  6. Troubleshooting PostgreSQL operations
    1.  
      Troubleshooting tips for NetBackup for PostgreSQL
    2.  
      Error during PostgreSQL credential addition
    3.  
      Error during the PostgreSQL instances and databases discovery phase
    4.  
      Error during the PostgreSQL Protection Plan Creation
    5.  
      Error while subscribing protection plan to PostgreSQL asset
    6.  
      Error while removing PostgreSQL asset
    7.  
      Error while backup of PostgreSQL asset
    8.  
      Error while restoring PostgreSQL asset image
  7. API for PostgreSQL instances and databases
    1.  
      Using APIs to manage, protect or restore PostgreSQL
  8.  
    Index

Configure PostgreSQL instance

You can configure PostgreSQL backup for user to perform backup and recovery by configuring the following environment variables:

Note:

Add these environment variables to the user for which NetBackup backup is to be run.

  • (optional) path - Add PostgreSQL bin path to this environment variable for running queries and connecting to databases.

  • (optional) LIB_PQ_PATH - For Windows set this environment variable to provide the location of libpq.dll library. For Linux set this environment variable to provide the location of libpq.so library.

  • (optional) PG_PRO_BACKUP_DUMP_DIRECTORY - Set this environment variable as temporary backup dump directory for non streaming backup. For example, On Linux computer, user can set this environment variable to required location using the command:

    echo "export PG_PRO_BACKUP_DUMP_DIRECTORY=/home/custom_dump_dir_location/" > > ~/.bashrc

    For Windows, user can create new environment variable and add path of folder location as:PG_PRO_BACKUP_DUMP_DIRECTORY=C:\custom_dump_dir_location

  • (optional) LVM SNAPSHOT_SIZE - Set this environment variable to provide the snapshot size for LVM backup for Linux operating system only. You can set environment variable of LVM Snapshot size to 500 MB using the command:echo "export LVM_SNAPSHOT_SIZE=500MB" >> ~/.bashrc

    Note:

    The default snapshot size is set to 500MB.

  • (optional) DELETE_WAL_LOGS - Set this environment variable to delete Wal logs after backup is done. The value can be set to 0 or 1.

  • PGSQL_COMPRESSION_VALUE - Level of compression which is given to the compression algorithm. Value can be between 0 and 9. Zero being lowest and nine being highest compression ratio.