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.