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
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) |