<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Not yet, still fumbling with the Simplfy
statement. But, as was said, it’s not really appropriate to have the
parcels display at that scale. This is more of an experiment to see how well I
can improve performance with PostGIS over shapefiles. Any advice is welcomed
on that.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Brent Fraser [mailto:bfraser@geoanalytic.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 16, 2012
9:55 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Bistrais, Bob<br>
<b><span style='font-weight:bold'>Cc:</span></b> Geomoose-users@lists.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Geomoose-users]
Trouble with PostGis layer on GM 2.2</span></font><font color=black><span
style='color:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>Cool. Did you sort out your performance problems
with the state-wide parcel layer?<br>
<br>
<br>
<o:p></o:p></span></font></p>
<pre><font size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Best Regards,<o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Brent Fraser<o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><br>
On 2/16/2012 7:52 AM, Bistrais, Bob wrote: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Yes, as it turns out, that’s what I had to do and
it’s working now.<u5:p></u5:p></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><u5:p> </u5:p></span></font><o:p></o:p></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> Brent Fraser [<a href="mailto:bfraser@geoanalytic.com">mailto:bfraser@geoanalytic.com</a>]
<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 16, 2012
9:37 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Bistrais, Bob<br>
<b><span style='font-weight:bold'>Cc:</span></b> <a
href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Geomoose-users]
Trouble with PostGis layer on GM 2.2</span></font><o:p></o:p></p>
</div>
<u5:p></u5:p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><u5:p> </u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'>If your PostGIS server and mapserver are on different
computers, make sure you've enabled Postgres to accept remote connects (edit
pg_hba.conf).<br>
<br>
<br>
<o:p></o:p></span></font></p>
<u5:p></u5:p><pre><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Best Regards,<u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Brent Fraser<u5:p></u5:p><o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'><br>
On 2/15/2012 12:50 PM, Bistrais, Bob wrote: <u5:p></u5:p><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><!--[if gte mso 9]><xml>
<u1:shapedefaults u2:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<u3:shapelayout u4:ext="edit">
<u3:idmap u4:ext="edit" data="1"/>
</u3:shapelayout>
</xml><![endif]-->Trying to implement some layers through PostGIS, and
I’m a PG newbie (some of you have seen my struggles on the other
lists). But now I am having trouble displaying a layer in GeoMoose
2.2. I think this may be related to the MapServer version, as this same
layer works fine with MapServer 6.0.1<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>The error message is as follows:<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>msPOSTGISLayerOpen(): Query error. Couldn't make
connection to DB with connect string<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>The connection strings:<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> DATA "the_geom from bb_connectme_rds
USING SRID=26919 USING Unique gid"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> CONNECTION "user=myusername
password=mypassword dbname=postgistest host=mymachinename port=5432"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> CONNECTIONTYPE postgis<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> PROCESSING "CLOSE_CONNECTION=DEFER"<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'><u6:p> </u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>As I mentioned, this all works fine on another
service using MapServer 6.0.1. Does PostGis work with GM 2.2? If
so, does it look like my connection strings are incorrect?<u6:p></u6:p></span></font><u5:p></u5:p><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br>
<o:p></o:p></span></font></p>
<pre><font size=2 color=black face="Courier New"><u5:p></u5:p><span
style='font-size:10.0pt'><fieldset class="mimeAttachmentHeader"></fieldset>_______________________________________________<u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Geomoose-users mailing list<u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'><a
href="mailto:Geomoose-users@lists.osgeo.org" moz-do-not-send=true>Geomoose-users@lists.osgeo.org</a><u5:p></u5:p><o:p></o:p></span></font></pre><pre><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'><a
href="http://lists.osgeo.org/mailman/listinfo/geomoose-users"
moz-do-not-send=true>http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><u5:p></u5:p><o:p></o:p></span></font></pre></div>
</body>
</html>