给你一配制文件样本吧,data目录下的pg_hba.conf,
linux下的(本机信任,其他所有机器可以MD5验证连接):
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 0.0.0.0 trust
# IPv6-style local connections:
host all all 0.0.0.0 0.0.0.0 md5如果系统是windows(本机信任,其他所有机器可以MD5验证连接):# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all 0.0.0.0/32 md5
linux下的(本机信任,其他所有机器可以MD5验证连接):
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 0.0.0.0 trust
# IPv6-style local connections:
host all all 0.0.0.0 0.0.0.0 md5如果系统是windows(本机信任,其他所有机器可以MD5验证连接):# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all 0.0.0.0/32 md5
按照上面的设置, 127.0.0.1可以访问, 如果换成机器的IP,不行, 因我是访问另一台机器, 所以只能是其它真实IP或那机器名.
那机的配置,192.168.1.5是我的机的IP
<property name="driverClassName">
<value>org.postgresql.Driver</value>
</property>
<property name="url">
<value>jdbc:postgresql://192.168.1.5:5432/departmanageforedu</value>
</property>
<property name="username">
<value>postgres</value>
</property>
<property name="password">
<value>123456</value>
</property>
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust# IPv4 local connections:
host all all 127.0.0.1/0 trust
# IPv6 local connections:
host all all 0.0.0.0/0 md5