[postgis-users] connecting to postgis from remote machines

Christian Mikovits christian.mikovits at uibk.ac.at
Mon Nov 19 08:19:21 PST 2012

Can you check if you have maybe a firewall up on the host machine?

on the host:
> netstat -tulp

on the client/remote:
> nmap -P 5432 $hostip


On Mon, Nov 19, 2012 at 4:36 PM, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:
> Hello,
> I am able to connect to postgis on a local machine, however I am having trouble connecting to PostGIS from remote machines.  The specific error I get is "FATAL: no_pg.conf entry for host "10.0.xxx.xxx", user "Editor", database "postgis20", SSL off."  I modified postgresql.conf so that the listen_addresses  is set to *, and made sure that ssl is set to off.  In addition I added a line in pg_hba.conf  for type host, database all, user all, IP-address *.
> Questions:
> 1)  I was not clear what to use for the method in pg_hba.conf.  I set it to md5 as that is what the other methods are using.
> 2) For testing I am using qgis 1.8.0 on a 32 bit machine to connect to postgis on a 64 bit machine.  Are there any known issues with connecting to 64 bit host from a 32 bit machine?
> Thank You
> Mark Volz
> GIS Specialist
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

More information about the postgis-users mailing list