NetBackup™ Web UI PostgreSQL Administrator's Guide

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

Quick configuration checklist to protect PostgreSQL instances and databases

Use NetBackup web UI to protect and restore the instances and databases that are created on the PostgreSQL platform. You can also use APIs for the same.

See Using APIs to manage, protect or restore PostgreSQL.

The following table describes the high-level steps to protect the PostgreSQL environment:

Table: Configure and protect PostgreSQL using NetBackup

Step overview

Description and reference

Deploy NetBackup to protect PostgreSQL instances and databases.

On a very high level to protect PostgreSQL instances and databases you need:

  • NetBackup primary server

  • NetBackup media server (Recommended)

  • NetBackup client that can act as a backup machine

PostgreSQL installed bin directory path should be added to path environment variable.

Verify if PostgreSQL installation bin path is set in environment variable. For Example:

  • For Windows :   PATH = C:\Program Files\PostgreSQL\14\bin

  • For Linux :  export PATH=$PATH:/usr/pgsql-13/bin

Protecting PostgreSQL instances and databases.

See Protect PostgreSQL instances and databases.