1.11. Files

> The file .pgpass in the home directory is a file that can contain passwords to be used if the connection requires a password. This file should have the format:

hostname:port:database:username:password

Any of these may be a literal name, or *, which matches anything. The first match will be used so put more specific entries first. Entries with : or \ should be escaped with \.

The permissions on .pgpass must disallow any access to world or group; achieve this by the command chmod 0600 .pgaccess. If the permissions are less strict than this, the file will be ignored.