[mapserver-users] No Postgresql mapserver images

[Michael McInnis]

Dang, how embarrassing. Following some bad online examples I had the wrong setting in the postgresql.conf filewhich when corrected enabled my mapserver to properly display postgresql geometry.
/etc/postgresql/9.1/main/postgresql.confI had :                                                              listen_addresses = '*'which needed to be :                                      listen_addresses = 'localhost'
Thank you for all the helpful responses in debugging this.
Michael McInnis
6033 44th Ave. N.E.
Seattle, WA 98115
206 517-4701

> Date: Sun, 28 Jul 2013 11:14:10 -0300
> From: jmckenna at gatewaygeomatics.com
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] No Postgresql mapserver images
> 
> On 2013-07-26 8:01 PM, Michael McInnis wrote:
> > Problem: Although I can use my mapserver install to draw shapefile maps
> > I can’t draw maps from my postgres source. I can also display the
> > postgres points in QGIS so I’m not sure what the problem is in mapserver.
> > 
> >  
> > 
> > Ideas? Thanks in Advance !
> 
> When I'm in this position, the first thing I try is the exact function
> call (from your error message) through a psql commandline call to
> Postgres/PostGIS.  Another thing to try is to duplicate this call
> through an ogrinfo commandline call to Postgres.
> 
> -jeff
> 
> 
> 
> 
> -- 
> Jeff McKenna
> MapServer Consulting and Training Services
> http://www.gatewaygeomatics.com/
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130729/f8aa96c5/attachment.htm>