I just tried this.
I get an error trying to connect to the database when I enter:
psql postgrestest -h 192.168.7.8 -U pgtest
The reply is:
psql: could not connect to server: Connection refused
Is the server running on host 192.168.7.8 and accepting TCP/IP connetions on port 5432?
I checked the ports:netstat -atpn
it tells me:tcp 127.0.0.1:5432 LISTEN 3713/postmaster
Which means that it is running.
Can someone tell me what I should do to get this working?
Also when I reboot the server it telles me it FAILED starting Postgresql.