Skip to content

Glossary: PostgreSQL for Developers

.pgpass

Also written: password file, PGPASSWORD, PGHOST, PGUSER

A password file in your home folder with one line per server (host:port:database:user:password), so scripts can connect without typing a password. On macOS and Linux it needs chmod 600. PGHOST and PGUSER are environment variables Postgres programs read.

Where the book teaches it

Related terms

environment variable