Re: Remote Server Connection Problem

Hi Ray,<br /><br />Thanks for your help. I forgot to tell you that I have done that. See below the hosts I put in
pg_hba.conffile:<br /><br />host rftDatabase "globus" "138.250.104.229" 255.255.255.255 md5<br />host rftDatabase
"globus""138.250.104.225" 255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.226" 255.255.255.255 md5<br
/>hostrftDatabase "globus" "138.250.104.227" 255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.228"
255.255.255.255md5<br />host rftDatabase "globus" "138.250.104.230" 255.255.255.255 md5<br />host rftDatabase "globus"
"138.250.104.231"255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.232" 255.255.255.255 md5<br /><br />I
havealso put all host in the /etc/hosts.allow file. I have read the client authentication of PostgreSQL. I am using
port5432 (default) for postgres to connect. It works fine for local servers but not for remote servers.<br /><br />Any
helpis highly appreciated.<br /><br />Kind regards<br />Gokop<br /><br /><b><i>rod@iol.ie</i></b> wrote:<blockquote
class="replbq"style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">
goteng1704@yahoo.comwrote:<br />> Error connecting to the server: FATAL: no pg_hba.conf entry<br />> for host
"138.250.104.229",user "globus", database<br />> "rftDatabase", SSL off<br />><br />> 138.250.104.229 is the
IPfor the local server, 138.250.104.232<br />> is the IP of the remote server, but is not showing it in the<br
/>>error.<br /><br />There's your problem - you need to give 138.250.104.229 permission to<br />connect to the
remoteserver by adding a suitable entry to pg_hba.conf -<br />look up "Client authentication" in the PostgreSQL
docs.<br/><br /><br />Ray.<br /><br /><br /><br /><br />http://www.iol.ie<br /></blockquote><br /><p><hr size="1" />Be
abetter pen pal. Text or chat with friends inside Yahoo! Mail. <a
href="http://us.rd.yahoo.com/evt=51732/*http://overview.mail.yahoo.com/">Seehow.</a>