Login to PostgreSQL without typing a Password

If you to connect to PostgreSQL without typing a password, you can do it by having your password in the file “.pgpass”.

The file reside in your home directory and must be readable to you only:

touch ~/.pgpass
chmod 600 ~/.pgpass

The format is simple:

hostname:port:database:username:password 

For example:

*:*:my_database:rayed:my_hard_password

The “*” means any host using any port.

This of course will work for “psql” and other tools to like “pg_dump”.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.