Re: BUG #12203: No password dialog when access the postgresql server - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12203: No password dialog when access the postgresql server
Date
Msg-id 5892.1418327380@sss.pgh.pa.us
Whole thread Raw
In response to BUG #12203: No password dialog when access the postgresql server  (wangzhipengkmust@126.com)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12204: Getting wrong results from full text search
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #12202: json operator ->>with offset