Re: Need help in enabling remote connection

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(dot)iisc(at)gmail(dot)com> wrote:

From: Shruthi A <shruthi(dot)iisc(at)gmail(dot)com>
Subject: [ADMIN] Need help in enabling remote connection
To: pgsql-admin(at)postgresql(dot)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

From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew