pgadmin4无法远程连接到centos7.3
在配置文件都做好，就是无法连接，看了资料， 说要配置服务器允许TCP/IP连接，不知如何配置那台centos7最小化安装，可以ping通外网，已经设置固定ip，web外网可以访问，就是pgadmin4无法访问。5432的防火墙端口也开了
psql: could not connect to server: Connection refused
Is the server running on host "server.joe.com" and accepting
TCP/IP connections on port 5432?
This is the generic "I couldn't find a server to talk to" failure. It looks like the above when TCP/IP communication is attempted. A common mistake is to forget to configure the server to allow TCP/IP connections.
自己解决了，原来头晕失眠检查错了，另一配置文件
这样改才行，希望对后生有用
vi /var/lib/pgsql/9.6/data/postgresql.conf
将listen_addresses前的#去掉，并将 listen_addresses = 'localhost' 改成 listen_addresses = '*'；
我有次也是，，其他的改完了，就是没有改listen_addresses.....
页:
[1]