2009/11/2 Shruthi A <shruthi.iisc@gmail.com>:
> 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.*
Try something like this:
listen_addresses = 'localhost,10.0.0.123'
port = 5432
assuming 123 is the correct number for your server's IP address
> -- 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
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/