Re: BUG #12203: No password dialog when access the postgresql server

wangzhipengkmust(at)126(dot)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