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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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 '' and not (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 <> 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-2017 The PostgreSQL Global Development Group