September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

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 matching entry will be used, so put more-specific entries first. When an entry contains : or \, it must be escaped with \.

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