Ok....Let's start from begin
1. Please check your port status in your server with familiar tools like
nmap. And make sure
there is a port for postrgresql (5432).
aris-deb:~# nmap 192.168.0.2
Starting nmap V. 2.54BETA31 ( www.insecure.org/nmap/ )
Interesting ports on (192.168.0.2):
(The 1547 ports scanned but not shown below are in state: closed)
Port State Service
9/tcp open discard
13/tcp open daytime
21/tcp open ftp
23/tcp open telnet
25/tcp open smtp
37/tcp open time
5432/tcp open postgres
Nmap run completed -- 1 IP address (1 host up) scanned in 3 seconds
2. If there is no postgresql port (5432) please check your packet filtering
(ipchains or iptables)
and allow for it.
3. For pg_hba.conf
TYPE DATABASE USER IP_ADRESS MASK AUTH_TYPE
local all all 167.205.240.67 255.255.255.0
trust
if yur configuration like this you just allow for IP 167.205.240.67/24 to
acces this server.
Can you change it to 167.205.240.0 to allow your network for accesing your
server.
Best regards
Aris Wendy