[postgis-users] connecting to postgis from remote machines

[Stephen V. Mather]

Hi Mark,
	I really wouldn't recommend that, unless you are behind a firewall
you really really really trust... .  Even then, I wouldn't recommend those
settings.  At least restrict your subnet, and preferably which users as well
(you can use an online subnet calculator, e.g.
http://www.subnet-calculator.com/ to help with this).  With the settings you
have you will (eventually) have someone doing things on your database that
you never intended, and likely maliciously.  You can (and should) ping the
PostgreSQL mailing list with recommended settings for listen addresses and
basic (but sane) security practices.

Best,
Steve

Stephen Mather
Geographic Information Systems (GIS) Manager
(216) 635-3243
svm at clevelandmetroparks.com
clevelandmetroparks.com




-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Mark Volz
Sent: Tuesday, November 20, 2012 1:03 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] connecting to postgis from remote machines

Hello,

I was able to allow remote connections by changing the listen address to *
in postgresql, and adding the following line in pg_hba.conf

host	 all	 all	 all	 md5 



Mark Volz
GIS Specialist


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users