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.

3. Make sure that the file has the correct permissions by running: chmod 600 .pgpass
4. Connect using the following command:

   psql -U username -d dbname
   

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'