[postgis-users] connecting to postgis from remote machines (Mark Volz)
MarkVolz at co.lyon.mn.us
Mon Nov 19 13:06:36 PST 2012
Here is a copy of my pg_hba entries. I only have one line that is not commented out.
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all * md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
> Message: 18
> Date: Mon, 19 Nov 2012 16:37:04 +0000
> From: Devrim G?nd?z <devrim at gunduz.org>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] connecting to postgis from remote
> Message-ID: <6abf4091-04ce-457c-8783-b19cae0dfa9c at email.android.com>
> Content-Type: text/plain; charset="utf-8"
> This is not a firewall issue. Please send us pg_hba.conf entries.
> 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
More information about the postgis-users