<div dir="ltr">Thanks Regina, that all makes complete sense.<div><br></div><div>Rich</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 9, 2015 at 8:53 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">Rich,</span></p><div><span class=""><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>I'm anxious to try postgis 2.2 (Visvalingam-Whyatt being the carrot for me).  From my Googling I'm under the impression that I can access multiple versions of postgis from a single instance of postgres. Am I correct?  <span style="color:#1f497d"><u></u><u></u></span></p></span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Yes.  I run multiple versions on a single instance all the time.<u></u><u></u></span></p><div><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></div><div><span class=""><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>When I build and install I don't think I need to change the prefix because things will go into 2.2 directories, correct? <span style="color:#1f497d"><u></u><u></u></span></p></span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Correct.  The postgis.control file gets overwritten though, so last install becomes the default PostGIS install when you don't explicitly set a version and during database restore.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><span class=""><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>And if my above understanding is correct, then my last question is when I create a new database how will I specify the postgis 2.2 extension rather than the existing version?<u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">If PostGIS 2.2.0 is the last install you did, your new database would be 2.2.0 with <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">CREATE EXTENSION postgis;<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">If you don't want that, edit the postgis.control file in share/extension folder back to old version.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">To explicitly state the version of PostGIS you want, you would do:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">CREATE EXTENSION postgis VERSION "2.1.8";<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Replacing 2.1.8 with version you want.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><span class=""><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">>  </span>Sorry, I realize these are pretty noob questions from a guy that's been using postgis for a long time...<span style="color:#1f497d"><u></u><u></u></span></p></span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">No need to be sorry. Lots of things change in how to do things and it is hard to keep up with changes in both PostGIS and PostgreSQL for anybody.<u></u><u></u></span></p></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>Thanks,<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>Rich<br clear="all"><u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">></span>-- <u></u><u></u></p><div><div><span class=""><p class="MsoNormal" style="margin-left:.5in"><span style="color:#1f497d">> </span>Richard W. Greenwood, PLS<br><span style="color:#1f497d">> </span><a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a><span style="color:#1f497d"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></span><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Hope that helps,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://postgis.net" target="_blank">http://postgis.net</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p></div></div></div></div></div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">Richard W. Greenwood, PLS<br><a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></div></div>
</div>