May 2018
Intermediate to advanced
576 pages
30h 25m
English
A password file contains the usual five fields that we require when connecting, as shown here:
host:port:dbname:user:password
Change this to the following:
myhost:5432:postgres:sriggs:moresecure
The password file is located using an environment variable named PGPASSFILE. If PGPASSFILE is not set, then a default filename and location must be searched for, as follows: