Sve zavisi gde ti je postgresql.conf. U mom slucaju:
cat /var/lib/postgres/data/postgresql.conf | grep listen_address
listen_addresses = 'localhost' # what IP address(es) to listen on;
dodaj mu samo tvoj ip...
/edit: pretece me termo...
make love - !war