Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group