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 <[email protected]> wrote:
From: Shruthi A <[email protected]>
Subject: [ADMIN] Need help in enabling remote connection
To: [email protected]
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
