BUG #12203: No password dialog when access the postgresql server
The following bug has been logged on the website:
Bug reference: 12203
Logged by: Grady
Email address: wangzhipengkmust@126.com
PostgreSQL version: 9.3.5
Operating system: Red hat 6.5
Description:
Hi Master
When i access the postgresql server, no password verfication appear.
My postgresql server[Revision:9.3.5] installed in REDHAT 6.5. I modifed
access method MD5 in the pg_hba.conf. When i used pgadmin and access the
server from localhost, everything is normal(password dialog appear).
The pg_hba.conf was as below:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 9.0.0.1/8 md5
host all all 172.0.0.1/8 md5
When I use the command in my window7 client:
"psql.exe -U postgres -h9.115.195.245"
After i typed enter, i directly accessed the postgres server. There isnt any
password dialog appear.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
wangzhipengkmust@126.com writes:
When i access the postgresql server, no password verfication appear.
My postgresql server[Revision:9.3.5] installed in REDHAT 6.5. I modifed
access method MD5 in the pg_hba.conf. When i used pgadmin and access the
server from localhost, everything is normal(password dialog appear).
The pg_hba.conf was as below:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 9.0.0.1/8 md5
host all all 172.0.0.1/8 md5
When I use the command in my window7 client:
"psql.exe -U postgres -h9.115.195.245"
After i typed enter, i directly accessed the postgres server. There isnt any
password dialog appear.
The most likely reason is that your windows machine has a .pgpass file
set up with the password.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs