Re: Need help in enabling remote connection - Mailing list pgsql-admin

From Brian Modra
Subject Re: Need help in enabling remote connection
Date
Msg-id 5a9699850911020758s1dc3b625rcbdd13a6120dc109@mail.gmail.com
Whole thread Raw
In response to Need help in enabling remote connection  (Shruthi A <shruthi.iisc@gmail.com>)
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: wstrzalka
Date:
Subject: Re: How can I know ./configure options for binary installation
Next
From: Sam Jas
Date:
Subject: Re: Need help in enabling remote connection