By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 985 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

how to connect a remote database in postgresql

P: 7
i want to connect a local remote database
Expand|Select|Wrap|Line Numbers
  1. 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
Apr 8 '13 #1
Share this Question
Share on Google+
8 Replies


10K+
P: 13,264
Do you have a pg_hba.conf entry for host "192.168.1.10"?
Apr 8 '13 #2

P: 7
yes added and reloaded the configuration file. but still issue persists
Apr 8 '13 #3

10K+
P: 13,264
Where did you add? You must add on the database you are trying to connect to.
Apr 8 '13 #4

P: 7
database configuration file only.
please provide clear answer
Apr 8 '13 #5

10K+
P: 13,264
You must add to the config file of the database on 192.168.1.2 and restart that.
Apr 8 '13 #6

P: 7
did the same thing, send me steps or provide docs
Apr 8 '13 #7

P: 7
what are the steps to remote a database, send me relevant on that docs, whatever u sent the docs already i have
Apr 8 '13 #9

Post your reply

Sign in to post your reply or Sign up for a free account.