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

From Sam Jas
Subject Re: Need help in enabling remote connection
Date
Msg-id 764301.87124.qm@web95009.mail.in2.yahoo.com
Whole thread Raw
In response to Need help in enabling remote connection  (Shruthi A <shruthi.iisc@gmail.com>)
List pgsql-admin

host all all 10.0.0.1/24 trust

>> host all all <IP/32> trust

-- In postgresql.conf, i added the line

listen_addresses = 10.0.0.*
>> listen_address = *

& then restart the server.


--
Thanks
Sam

--- On Mon, 2/11/09, Shruthi A <shruthi.iisc@gmail.com> wrote:


From: Shruthi A <shruthi.iisc@gmail.com>
Subject: [ADMIN] Need help in enabling remote connection
To: pgsql-admin@postgresql.org
Date: Monday, 2 November, 2009, 1:26 PM

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


Connect more, do more and share more with Yahoo! India Mail. Learn more.

pgsql-admin by date:

Previous
From: Brian Modra
Date:
Subject: Re: Need help in enabling remote connection
Next
From: donghe@caltech.edu
Date:
Subject: can not create user name in Capital letter