Re: Remote Server Connection Problem

Hi Ray,

Thanks for your help. I forgot to tell you that I have done that. See below the hosts I put in pg_hba.conf file:

host rftDatabase "globus" "138.250.104.229" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.225" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.226" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.227" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.228" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.230" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.231" 255.255.255.255 md5
host rftDatabase "globus" "138.250.104.232" 255.255.255.255 md5

I have also put all host in the /etc/hosts.allow file. I have read the client authentication of PostgreSQL. I am using port 5432 (default) for postgres to connect. It works fine for local servers but not for remote servers.

Any help is highly appreciated.

Kind regards
Gokop

rod(at)iol(dot)ie wrote: goteng1704(at)yahoo(dot)com wrote:
> Error connecting to the server: FATAL: no pg_hba.conf entry
> for host "138.250.104.229", user "globus", database
> "rftDatabase", SSL off
>
> 138.250.104.229 is the IP for the local server, 138.250.104.232
> is the IP of the remote server, but is not showing it in the
> error.

There's your problem - you need to give 138.250.104.229 permission to
connect to the remote server by adding a suitable entry to pg_hba.conf -
look up "Client authentication" in the PostgreSQL docs.

Ray.

http://www.iol.ie

---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.