[postgis-users] connecting to postgis from remote machines (Mark Volz)

[Mark Volz]

Devrim,

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

Mark Volz
GIS Specialist


> 
> 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
> 	machines
> Message-ID: <6abf4091-04ce-457c-8783-b19cae0dfa9c at email.android.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Hi,
> 
> This is not a firewall issue. Please send us pg_hba.conf entries.
> 
> Regards,
> Devrim
> 
> 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
> >