Re: Need help in enabling remote connection

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need help in enabling remote connection
Date: 2009-11-02 13:39:32
Message-ID: 4AEEE114.4020108@nsoft.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I think you make mistake writing "listen_addresses = 10.0.0.*". I doubt
it can be done like this... Try "listen_addresses = '*'" first. Also
see, that addresses are in form '10.0.0.1' and not 10.0.0.1. (use ' )
If this doesn't help try telneting server (port 5432) from client
mashine. Maybe theres a firewall in between??

2009.11.02 15:26, Shruthi A rašė:
> 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 <http://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
>

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message wstrzalka 2009-11-02 14:36:58 How can I know ./configure options for binary installation
Previous Message Shruthi A 2009-11-02 13:26:47 Need help in enabling remote connection