Hello,
I think you make mistake writing "listen_addresses = 10.0.0.*". I doubt it can be done like this... Try "listen_addresses = '*'" first. Also see, that addresses are in form '10.0.0.1' and not 10.0.0.1. (use ' )
If this doesn't help try telneting server (port 5432) from client mashine. Maybe theres a firewall in between??
2009.11.02 15:26, Shruthi A rašė:
Hi,
I want a postgres client to be able to connect to a postgres sever on a remote machine. But i'm not able to make it work. Assume both the machines are on a LAN 10.0.0.* .Following available advice, this is what i did:
-- In pg_hba.conf, i added the line
host all all 10.0.0.1/24 trust
-- In postgresql.conf, i added the line
listen_addresses = 10.0.0.*
-- Restarted the server with the cmd
./pg_ctl -D <data_folder> reload
This doesn't work. What else should i do to make remote connection work?
I'm lost! Please help!
Thanks a lot,
Shruthi
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050