[postgis-users] connecting to postgis from remote machines
dgolicher at gmail.com
Mon Nov 19 08:13:05 PST 2012
I have a similar setup with a 64 bit machine.
My liine in hba_conf looks like this
host all all 0.0.0.0 0.0.0.0 md5
And I can connect from 32 bit and Windows using QGIS and ODBC.
On Mon, Nov 19, 2012 at 9:36 AM, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:
> 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 *.
> 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
Dr Duncan Golicher
El Colegio de la Frontera Sur, Chiapas,Mexico
Mexico tel +52 1 967 137 94 20
Skype name duncangolicher
Senior lecturer, Bournemouth University, UK
Centre for Conservation Ecology & Environmental Change
School of Applied Sciences
Christchurch House rm C218a
Poole (Dorset) BH12 5BB UK
Tel. +44 (0)1202 961682
For list of publications see Researcher ID:
dgolicher at bournemouth.ac.uk
dgoliche at ecosur.mx
More information about the postgis-users