how to connect a remote database in postgresql

[surk16]

i want to connect a local remote database

select dblink('host=192.168.1.2 dbname=postgres user=postgres password=webgis',' select * from test');

however i am getting a below error message,
ERROR: could not establish connection
DETAIL: FATAL: no pg_hba.conf entry for host "192.168.1.10", user "postgres", database "postgres", SSL off

kindly please any one can help me

[r035198x]

Do you have a pg_hba.conf entry for host "192.168.1.10"?

[surk16]

yes added and reloaded the configuration file. but still issue persists

[r035198x]

Where did you add? You must add on the database you are trying to connect to.

[surk16]

database configuration file only.
please provide clear answer

[r035198x]

You must add to the config file of the database on 192.168.1.2 and restart that.

[surk16]

did the same thing, send me steps or provide docs

[r035198x]

http://www.postgresql.org/docs/9.0/s...-problems.html

http://www.postgresql.org/docs/9.0/s...-hba-conf.html

[surk16]

what are the steps to remote a database, send me relevant on that docs, whatever u sent the docs already i have