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.iisc@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
