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

Configuring PostgreSQL backups with DataStore policies

The agent uses the Datastore policies to define the attributes, schedules, clients list, and backup selections.

To configure the PostgreSQL database backups with DataStore policies, complete the following steps:

  1. Log on to the master server as an administrator (Windows) or root (Linux).
  2. In the NetBackup Administration Console, expand NetBackup Management, and then click Policies.
  3. In All Policies pane, right-click Summary of All Policies, and then click New Policy.
  4. In Add a New Policy dialog box, enter the unique policy name.
  5. In the Change Policy dialog box, select DataStore Policy from the Policy Type drop-down list.
  6. From the Policy Storage list, select a disk-based storage unit for storage.
  7. To select the schedule type, under the Schedules tab, click OK to select the Application Backup schedule type.

    Note:

    The XBSA framework supports the Application backup schedule type only.

  8. In the Clients tab, click New and then add the NetBackup client that has the NetBackup for PostgreSQL Agent.
  9. In the Add Client screen, click New, and then in the Client Name field, type the name of the client.
  10. In the NetBackup Administration Console, click NetBackup Management > Policies to view the policy in the existing policies list.
  11. Before performing the backup, review the settings in the nbpgsql.conf file.

    For more information, see See The nbpgsql.conf configuration file.

Note:

Ensure that the PostgreSQL agent and NetBackup are of same version for successful backup and restore operations.