Files

PostgreSQL 7.3.4 Documentation
Prev | Chapter 1. libpq - C Library | Next

# 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.

Prev | Home | Next
Environment Variables | Up | Threading Behavior