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

Authenticating the password

Authenticating the password keeps you from specifying the password every time you run a backup. The password file stores the password and the application picks the password every time you run a backup.

The password file

The password file for Windows is pgpass.conf and for Linux it is .pgpass file.

The password file must contain the lines of the following format:

hostname:port:database:username:password

In Linux, after you edit the .pgpass file, change the .pgpass file permissions.

Authenticating the password on Windows

To authenticate the password

  1. Run the following command:

    >echo%AppData%

    O/P: C:\Users\Administrator\AppData\Roaming

  2. Create postgresql directory in C:\Users\Administrator\AppData\Roaming path.
  3. Create pgpass.conf in the postgresql directory.
  4. In the pgpass.conf file update the following and then save the file.

    hostname:port:database:username:password

    For example, localhost:5432:*:postgres:test_123

  5. Restart the postgres services.
Authenticating the password on Linux

To authenticate the password

  1. Create .pgpass file in the user's home directory.
  2. Edit the .pgpass file as:

    hostname:port:database_name:username:password

  3. To change the .pgpass file permissions, run the following command:

    $ chmod 0600 ~/.pgpass