wiki:Postgres HowTo login without password

Postgres HowTo login without password

tags: postgres HowTo


  1. Create a file in your home directory called .pgpass
  2. The contents of this file should take the format:

For example, here the port and database have been left blank:


You may have to add a record for as well as localhost.

  1. Make sure that the file has the correct permissions by running: chmod 600 .pgpass
  2. Connect using the following command:
    psql -U username -d dbname

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Last modified 8 years ago Last modified on 08/30/16 12:32:08
Note: See TracWiki for help on using the wiki.