Postgresql远程连接设置

Question

pg_hba.conf

已经修改

IPv4 local connections:

host all all 127.0.0.1/32 trust
host all all 192.168.1.0/24 md5

postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;

可是还是会提示
Unable to connect to server:

could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "192.168.1.205" and accepting
TCP/IP connections on port 5432?

Answer 1

查看你的服务器端postgresql进程启动了，并且侦听在5432端口等。可以用netstat查看一下