Postgresql 允许远程连接

Postgresql9.5 允许远程连接

1 修改pg_hba.conf
添加允许访问IP
host all all 0.0.0.0/0 md5
2 修改监听配置
修改 postgresql.conf文件,允许所有的链接

#listen_addresses = ‘localhost’ # what IP address(es) to listen on;
listen_addresses = ‘*’ # what IP address(es) to listen on;

重启数据库,客户端连接

启动服务
systemctl start postgresql.service
停止服务
systemctl stop postgresql.service
重启服务
systemctl restart postgresql.service
查看一个服务的状态
systemctl status postgresql.service
开机时启用一个服务
systemctl enable postgresql.service
开机时关闭一个服务
systemctl disable postgresql.service
查看服务是否开机启动
systemctl is-enabled postgresql.service

== 注意防火墙(千万注意) ==

修改用户密码
su - postgres;
psql
ALTER USER postgres WITH PASSWORD ‘password’;