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 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.
To authenticate the password
- Run the following command:
>echo%AppData%O/P: C:\Users\Administrator\AppData\Roaming - Create
postgresqldirectory inC:\Users\Administrator\AppData\Roamingpath. - Create
pgpass.confin thepostgresqldirectory. - In the
pgpass.conffile update the following and then save the file.hostname:port:database:username:passwordFor example,
localhost:5432:*:postgres:test_123 - Restart the postgres services.
To authenticate the password
- Create
.pgpassfile in the user's home directory. - Edit the
.pgpassfile as:hostname:port:database_name:username:password
- To change the
.pgpassfile permissions, run the following command:$ chmod 0600 ~/.pgpass