NetBackup™ for PostgreSQL Administrator's Guide

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

Add a PostgreSQL instance

You can add a PostgreSQL instance and its credentials.

To add PostgreSQL instance and its credentials

  1. On the left, click PostgreSQL then click the Instances tab.
  2. Click Add to add a PostgreSQL instance and enter the following:

    • Host

    • Instance name

  3. Enter or use the up, down arrow keys to add details of Port number.
  4. Click Next.

    Note:

    You will be redirected to the Permissions page and you can also manage credentials of the created instance.

  5. Click Finish.

    Note:

    If you click Previous, instance created will not be saved.

Assign permissions to PostgreSQL instance

You can assign permissions to an instance added.

To assign permissions to the PostgreSQL instance

  1. Click Add to add permissions to this instance.
  2. Select role and permissions.
  3. Click Save > Finish.
Inline actions on PostgreSQL instance

You can run the following inline actions on a PostgreSQL instance:

  • Recover: Recovers the PostgreSQL instance.

  • Manage credentials: Manages the instance credentials.

  • Deactivate: Deactivates the PostgreSQL instance.

  • Remove: Removes the PostgreSQL instance.

Actions on multiple PostgreSQL instances

You can select one or more PostgreSQL instances and perform the following actions:

  • Deactivate: Deactivates the PostgreSQL instances.

  • Manage credentials: Manages the credentials of the PostgreSQL instances.

  • Remove: Removes the selected PostgreSQL instances.

Auto-discovered cluster asset:

  • PostgreSQL primary node instance is discovered and added in web UI asset automatically.

  • PostgreSQL standby node instance is discovered and added in web UI asset automatically.