From: | Brian Modra <brian(at)zwartberg(dot)com> |
---|---|
To: | Shruthi A <shruthi(dot)iisc(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Need help in enabling remote connection |
Date: | 2009-11-02 15:58:30 |
Message-ID: | 5a9699850911020758s1dc3b625rcbdd13a6120dc109@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2009/11/2 Shruthi A <shruthi(dot)iisc(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Jas | 2009-11-02 17:52:40 | Re: Need help in enabling remote connection |
Previous Message | wstrzalka | 2009-11-02 15:54:29 | Re: How can I know ./configure options for binary installation |