NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (10.1)

Authenticating the PostgreSQL environment password

Authenticating the PostgreSQL environment 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