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

Redirected restores

Redirected restores lets you restore backup files to a client different from the client that originally performed the backup. The new location can be a different host or a different file path using a different name for the redirected restore. To redirect a restore to a different host, include the destination client name in the install_path\NetBackup\db\altnames directory.

Note:

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

Performing redirected restores

To redirect a restore to a different host

  1. Update the nbpgsql.conf file with the NetBackup client name as the host and the PostgreSQL target directory as the directory where you want to redirect the restore.
  2. On the NetBackup master server, create an altnames directory for the host that you want to have permission to perform the redirected restore. For example, to give Host B permissions to restore from another host, create the following file:

    • (Windows) install_path\NetBackup\db\altnames\HostB

    • (Linux RHEL and SLES) /usr/openv/netbackup/db/altnames/HostB

  3. In the altnames directory, add the names of the client(s) whose files the requesting client wants to restore. For example, if you want Host B to have permissions to redirect restores from Host A, add Host A to the Host B file.
  4. Run the following command:

    nbpgsql -o restore -S master_server_name -t target_directory -portnum db_port [-id db_backup_id] [-C client_name]

  5. After a successful redirected restore, undo the changes that you made on the master server and the client.

To redirect a restore to a different file path

  1. Run the following command:

    nbpgsql -o restore -S master_server_name -t target_directory -portnum database_server_port [-id db_backup_id] [-C client_name]

  2. Copy the restore data to the data directory.
  3. After a successful restore, change the ownership of data directory to PostgreSQL user and modify the settings according to your environment.