<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Dang, how embarrassing. Following some bad online examples I had the wrong setting in the postgresql.conf file<div>which when corrected enabled my mapserver to properly display postgresql geometry.</div><div><br></div><div>/etc/postgresql/9.1/main/postgresql.conf</div><div>I had : listen_addresses = '*'</div><div>which needed to be : listen_addresses = 'localhost'</div><div><br></div><div>Thank you for all the helpful responses in debugging this.</div><div><br>Michael McInnis
6033 44th Ave. N.E.
Seattle, WA 98115
206 517-4701<br><br><div>> Date: Sun, 28 Jul 2013 11:14:10 -0300<br>> From: jmckenna@gatewaygeomatics.com<br>> To: mapserver-users@lists.osgeo.org<br>> Subject: Re: [mapserver-users] No Postgresql mapserver images<br>> <br>> On 2013-07-26 8:01 PM, Michael McInnis wrote:<br>> > Problem: Although I can use my mapserver install to draw shapefile maps<br>> > I can’t draw maps from my postgres source. I can also display the<br>> > postgres points in QGIS so I’m not sure what the problem is in mapserver.<br>> > <br>> > <br>> > <br>> > Ideas? Thanks in Advance !<br>> <br>> When I'm in this position, the first thing I try is the exact function<br>> call (from your error message) through a psql commandline call to<br>> Postgres/PostGIS. Another thing to try is to duplicate this call<br>> through an ogrinfo commandline call to Postgres.<br>> <br>> -jeff<br>> <br>> <br>> <br>> <br>> -- <br>> Jeff McKenna<br>> MapServer Consulting and Training Services<br>> http://www.gatewaygeomatics.com/<br>> _______________________________________________<br>> mapserver-users mailing list<br>> mapserver-users@lists.osgeo.org<br>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br></div></div> </div></body>
</html>