pgadmin4無(wú)法遠(yuǎn)程連接到centos7.3

eremiter

在配置文件都做好，就是無(wú)法連接，看了資料， 說(shuō)要配置服務(wù)器允許TCP/IP連接，不知如何配置
那臺(tái)centos7最小化安裝，可以ping通外網(wǎng)，已經(jīng)設(shè)置固定ip，web外網(wǎng)可以訪問(wèn)，就是pgadmin4無(wú)法訪問(wèn)。5432的防火墻端口也開(kāi)了

1. psql: could not connect to server: Connection refused
   
2.         Is the server running on host "server.joe.com" and accepting
   
3.         TCP/IP connections on port 5432?
   
4. 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.

復(fù)制代碼

eremiter

自己解決了，原來(lái)頭暈失眠檢查錯(cuò)了，另一配置文件

這樣改才行，希望對(duì)后生有用

1. vi /var/lib/pgsql/9.6/data/postgresql.conf
   
2. 
   
3. 將listen_addresses前的#去掉，并將 listen_addresses = 'localhost' 改成 listen_addresses = '*'；
   

復(fù)制代碼

mr_la

我有次也是，，其他的改完了，就是沒(méi)有改listen_addresses.....