Re: Need help in enabling remote connection

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(dot)iisc(at)gmail(dot)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
>