wiki:Postgres HowTo login without password

Postgres HowTo login without password

tags: postgres HowTo

Procedure

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

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

localhost:*:*:username:password

You may have to add a record for 127.0.0.1 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 6 years ago Last modified on 08/30/16 12:32:08
Note: See TracWiki for help on using the wiki.