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.i...@gmail.com> wrote: From: Shruthi A <shruthi.i...@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 From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew