Changes between Initial Version and Version 1 of Postgres HowTo login without password

Timestamp:

08/30/16 12:32:08 (8 years ago)

Author:

Richard Bramley

Comment:

--

Postgres HowTo login without password

@@ +1 @@
+= 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
+}}}
+
+
+
+[[BackLinks]]