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@xxxxxxxxx> wrote:
From: Shruthi A <shruthi.iisc@xxxxxxxxx> Subject: [ADMIN] Need help in enabling remote connection To: pgsql-admin@xxxxxxxxxxxxxx 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.