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

From Julius Tuskenis
Subject Re: Need help in enabling remote connection
Date
Msg-id 4AEEE114.4020108@nsoft.lt
Whole thread Raw
In response to Need help in enabling remote connection  (Shruthi A <shruthi.iisc@gmail.com>)
List 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 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
Attachment

pgsql-admin by date:

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