Search Postgresql Archives

Re: MD5 password issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> writes:
> In pg_hba.conf we have:

> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

> # "local" is for Unix domain socket connections only
> local   all         all                               ident sameuser

> # IPv4 local connections:
> host    all         all         127.0.0.1/32          md5
> host    all         all         192.168.97.0/24       md5

> Now the question: why is the user pgadmin able to connect to the database using pgAdmin
> III from 192.168.97.30? That sould not be possible ... or am I wrong?

Why shouldn't it be possible?  You've specifically allowed connections
from that IP range.

(If you're wondering why he didn't have to type his password,
it's likely because pgAdmin is getting it out of ~/.pgpass or
some private settings file.)

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux