Hi all, Thanks a lot for all your replies. The problem is solved now. This is the correct thing to do: listen_addresses = '*' And then restart the service.
Additional notes: -- Remember to use single quotes around the * else it will give syntax error. -- The listen_addresses parameter specifies the client addresses, and not the server. -- Once this service is started, telneting the server on the given port successfully connects. -- Dear Ian Lea, i guess 10.0.0.1/24 is the same as 10.0.0.0/24 as the mask '24' means that the first 3 octets (24 bits from the left hand side) must match ie both mean simply 10.0.0.* -- And i think 'trust' should be fine assuming that this will be used on an isolated network with a few trusted machines or a secure network where a firewall protects a given set of ports. -- Dear Brian Modra, i guess listen_addresses = 'localhost,10.0.0.123' will give error. It should be written as listen_addresses = 'localhost','10.0.0.123' that is each IP should be quoted separately. Thanks again, Shruthi On Mon, Nov 2, 2009 at 6:56 PM, Shruthi A <shruthi.i...@gmail.com> wrote: > 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 >
