Veritas NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.1)
  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
    5.  
      NetBackup for PostgreSQL Agent Documentation
  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. The NetBackup for PostgreSQL backups and restores
    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 PostgreSQLrestores
    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

About PostgreSQL restore

The nbpgsql -o restore command for restore initiates the restore operation using -S and-t as the required parameters. The parameters -id and -C are optional parameters.

The parameter -id restores the backup using the specified backup image name. The parameter -C lists all the backups that exists on the specified client. When you do not specify -C, it defaults to NetBackup master server.

Figure: NetBackup for PostgreSQL restore workflow

NetBackup for PostgreSQL restore workflow
The NetBackup for PostgreSQL restore workflow

After you specify the parameters, the agent reads the command line arguments and parses the nbpgsql.conf configuration file. The agent then interacts with the NetBackup XBSA interface to retrieve the backup. using the specified parameters.

The NetBackup XBSA interface reads the progress files to receive the PostgreSQL backup files to restore them to the target directory.

The command prompt indicates the successful completion status of the restore. The Activity Monitor displays the status for the restore job.

In Linux operating systems, after a successful restore, the owner and group of the restored data defaults to postgres. You must change the ownership to PostgreSQL user and modify the settings according to your environment.

In Linux operating system, if the data directory contains symbolic link, the backup does not retain the link information. The symbolic link gets backed up as a normal data directory and is restored as a normal directory. To restore the link, you must reconfigure the symbolic link.

Note:

Ensure that the target directory is valid and empty.

Prerequisites

Before you run a restore, ensure that you meet the following prerequisites:

  • (LVM users) Ensure that data logs and the logs directory reside on logical volumes.

  • Set the following parameters in the nbpgsql.conf file:

    • PGSQL_TARGET_DIRECTORY

    • MASTER_SERVER_NAME

    • DB_PORT

    • CLIENT_NAME

    • DB_BACKUP_ID