<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>I am upgrading from postgis 2.1.1 to 2.1.7 using extensions.</div>
<div><br>
</div>
<div>After entering the following,</div>
<div><br>
</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>ALTER EXTENSION postgis UPDATE TO "2.1.7”;</div>
<div><br>
</div>
<div>I get error </div>
<div><br>
</div>
<div>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px;">
<p style="margin: 0px; font-size: 12px; font-family: Times;">ERROR: extension "postgis" has no update path from version "2.1.1" to version "2.1.7"</p>
<p style="margin: 0px; font-size: 12px; font-family: Times; min-height: 14px;"><br>
</p>
<p style="margin: 0px; font-size: 12px; font-family: Times;">********** Error **********</p>
<p style="margin: 0px; font-size: 12px; font-family: Times; min-height: 14px;"><br>
</p>
<p style="margin: 0px; font-size: 12px; font-family: Times;">ERROR: extension "postgis" has no update path from version "2.1.1" to version "2.1.7"</p>
<p style="margin: 0px; font-size: 12px; font-family: Times;">SQL state: 22023</p>
</blockquote>
</div>
<div><br>
</div>
<div><br>
</div>
<div>The documentation says</div>
<div><br>
</div>
<div>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px;">
<p style="font-size: 10pt; color: rgb(46, 46, 46); font-family: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif;">
If you get an error notice something like:</p>
<pre class="programlisting" style="border-width: 2px 0px; font-family: 'Courier New', Courier, Monaco, monospace; line-height: 16px; border-color: rgb(247, 147, 30); border-style: solid; font-size: 11px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; background-color: rgb(248, 248, 249); border-top-left-radius: 2px; border-top-right-radius: 2px; border-bottom-right-radius: 2px; border-bottom-left-radius: 2px; color: rgb(46, 46, 46);">No migration path defined for ... to 2.1.9dev</pre>
<p style="font-size: 10pt; color: rgb(46, 46, 46); font-family: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif;">
Then you'll need to backup your database, create a fresh one as described in <a class="xref" href="http://postgis.net/docs/manual-2.1/postgis_installation.html#create_new_db_extensions" title="2.6. Creating a spatial database using EXTENSIONS" style="text-decoration: none; color: rgb(65, 138, 205);">Section 2.6,
“Creating a spatial database using EXTENSIONS”</a> and then restore your backup ontop of this new database.</p>
</blockquote>
</div>
<div><br>
</div>
<div>Is it typical to have no update path within 2.1.x versions? How many versions typically have an upgrade path? Am I wrong in saying that extensions have a worse upgradeability within 2.1.x versions as compared to not using the extensions or would the
postgis_upgrade_21_minor.sql also fail going from 2.1.1 to 2.1.7.</div>
<div><br>
</div>
<div>Thanks for any insight,</div>
<div><br>
</div>
<div>Paul</div>
<span id="OLK_SRC_BODY_SECTION">
<div>
<div>
<div dir="ltr">
<div>
<div>
<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;">
<p></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</span>
</body>
</html>