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 <http://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
smime.p7s
Description: S/MIME Cryptographic Signature