BUG #13188: .pgpass does not work

From: bzb(dot)dev001(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13188: .pgpass does not work
Date: 2015-04-28 18:10:07
Message-ID: 20150428181007.2546.64960@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13188
Logged by: wt
Email address: bzb(dot)dev001(at)gmail(dot)com
PostgreSQL version: 9.4.1
Operating system: linux
Description:

Tried to use ~/.pgpass file to automatically specify the password when I use
the psql console app. according to the info from "PostgreSQL 9.4.0
Documentation", Section 31.15. The Password File.

Postgresql is configured to use md5 for login.

file: pg_hba.conf
-----------------
local all all md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

file: ~/.pgpass
---------------
#hostname : port : database : username : password
* : 5432 : * : postgres : somepassword

When I exec psql without specifying the password, I cannot login...

$ psql --host=localhost --port=5432 --username=postgres --no-password
psql: fe_sendauth: no password supplied

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2015-04-28 18:13:48 Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message Alvaro Herrera 2015-04-28 17:54:14 Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)