[postgis-users] connecting to postgis from remote machines

Stephen V. Mather svm at clevelandmetroparks.com
Tue Nov 20 11:46:48 PST 2012

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.


Stephen Mather
Geographic Information Systems (GIS) Manager
(216) 635-3243
svm at 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


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

More information about the postgis-users mailing list