[postgis-users] connecting to postgis from remote machines

Nicolas Ribot nicolas.ribot at gmail.com
Mon Nov 19 08:27:24 PST 2012


Hi

A running firewall ?

Nicolas


On 19 November 2012 17:13, Duncan Golicher <dgolicher at gmail.com> wrote:

> Hello Marc,
>
> 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.
>
> Duncan
>
>
>
> On Mon, Nov 19, 2012 at 9:36 AM, 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
>
>
>
> --
> Dr Duncan Golicher
> Investigador Titular,
> El Colegio de la Frontera Sur, Chiapas,Mexico
> Mexico tel +52 1 967 137 94 20
> Skype name duncangolicher
>
> Publications: http://www.mendeley.com/profiles/duncan-golicher
>
> Senior lecturer, Bournemouth University, UK
> Centre for Conservation Ecology & Environmental Change
> School of Applied Sciences
> Christchurch House rm C218a
> Bournemouth University
> Fern Barrow
> Poole (Dorset) BH12 5BB UK
> Tel. +44 (0)1202 961682
>
> For list of publications see Researcher ID:
> http://www.researcherid.com/rid/B-4240-2009
>
> dgolicher at bournemouth.ac.uk
> dgoliche at ecosur.mx
>
> Researcher ID:
> http://www.researcherid.com/rid/B-4240-2009
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121119/a44d06c6/attachment-0001.html>


More information about the postgis-users mailing list