[postgis-users] Establishing a remote connection to postgis

[Barend Köbben]

Hi,
 
did you check if the port  5432 is open on any firewalls between you and the remote server?
Also, if you try connecting from a remote machine, why do you fill in 127.0.0.1 as the ip? That is the localhost ip, ie. it' sfor connecting from the server the DB is running on. Try filling in the actual ip of your client machine...
 
-- 
Barend Köbben 
International Institute for Geo-information Sciences and  Earth Observation (ITC) 
PO Box 6, 7500AA Enschede (The Netherlands) 
ph: +31-(0)534874253; mobile: +31-(0)622344955

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Steven De Vriendt
Sent: Fri 1/12/07 09:36
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Establishing a remote connection to postgis


Hi all,

I try to connect to my postgis db on a remote server. I use Quantum GIS 0.7.4 and Udig 1.0.6 for doing this.
When I try to connect I get the following error message, in both of the applications: 

"erroneous pg_hba conf file" 

So I look at my pg_hba conf file. I have added this line to the pg_hba conf file in
order to estabalish connections from outside my LAN.

host    all     127.0.0.1 <http://127.0.0.1/>        255.255.255.255 <http://255.255.255.255/>  md5

For now it looks like this:
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
#host    all         all         ::1/128               md5
host    all     127.0.0.1 <http://127.0.0.1/>        255.255.255.255 <http://255.255.255.255/> md5


I've tried to find the "tcpip_socket" connection parameter, but I can't seem to
find it in the postgresql.conf file, using PostgreSQL 8.1...

Following that I've started the postmaster with the -i flag and -D- flag pointing 
to my data directory.

Can someone help me out ?

Thanks in advance


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 5776 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070112/86c9681b/attachment.bin>