postgres相关

java攻城狮

发布于 2020-10-10 16:14:05

1.1K00

代码可运行

文章被收录于专栏：个人积累个人积累

运行总次数：0

代码可运行

本地数据库安装，默认使用`localhost`连接，使用`ip`连接报错问题?

找到数据库安装的路径，在data文件夹下找到pg_hba.conf修改地址访问配置

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             192.168.0.0/0           md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
host    all             all             192.168.0.0/0           md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

host    all             all             192.168.0.0/0           md5

在IPv6处添加 host all all 192.168.0.0/0 md5