<div dir="ltr"><div>Thanks for help, I was renaming the wrong file. </div><div>Finaly i ran:</div><div>"cp postgis--2.0.0alpha6--2.0.0.sql postgis--2.0.0alpha7SVN--2.0.0.sql"</div><div>Then i updated to 2.0.0 and later from 2.0.0 to 2.1.0 successfully.</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/11/7 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>Armando,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>That's the wrong one to rename since
that is a meant for a clean new install. It's better to copy anyway but
renaming is fine.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>use the file
called <strong>postgis--2.0.0--2.1.0.sql</strong>
</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>and call it
<strong>postgis--2.0.0alpha7SVN.sql--2.1.0.sql</strong></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div><span></span><font color="#0000ff" face="Arial">You might still run into errors<span> (but they will be
different)</span> .</font></div>
<div><font face="Arial"><font color="#0000ff"><font></font></font></font> </div>
<div><font color="#0000ff" face="Arial"></font> </div>
<div><span><font color="#0000ff" face="Arial">pramsey,</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">You
recall what got changed between 2.0.0 alpha and beta? I know there is a
reason I didn't want people upgrading from alpha version but can't remember what
it was. It was some change you made around beta1 or beta2 release is all I
recall.</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><br></div>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Armando Pardo
Zepeda<br><b>Sent:</b> Thursday, November 07, 2013 6:10 PM<div class="im"><br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> Re: [postgis-users] Error updating
PostGIS<br></div></font><br></div>
<div></div>
<div dir="ltr">
<div>Thanks for reply. The "pg_config --sharedir" is: /usr/share/postgresql/9.1
directory. </div>
<div>All files of the postGIS versions I installed are there (2.0.0alpha7SVN and
2.1.0). </div>
<div><br></div>
<div>I tried renaming the file postgis--2.1.0.sql to
postgis--2.0.0alpha7SVN.sql but I get the same error message.</div>
<div><br></div>
<div>The database is big and I wish do the upgrade of postGIS without do backup
and restore if it is possible.</div></div><div><div class="h5">
<div class="gmail_extra"><br><br>
<div class="gmail_quote">2013/11/7 Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT:1ex;MARGIN:0px 0px 0px 0.8ex;BORDER-LEFT:#ccc 1px solid">The
safest is to do a backup and restore. The restoration will use
the<br>newest postgis you have unless you pre-install a new db with
CREATE<br>EXTENSION postgis VERSION "something"<br><br><br>Normally I'd advice
to just copy the postgis--2.0.0-2.1.0.sql
to<br>postgis--2.0.0alpha7SVN-2.1.0.sql and repeat your ALTER
EXTENSION<br><br>but I recall some major breaking changes (last minute ondisk
I think)<br>between the 2.0.0 beta1 and 2.0.0 beta2 that would necessitate a
dump<br>restore otherwise you'd run into issues down the line.<br><br>Hope
that helps,<br>Regina<br><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br><a href="http://postgis.net" target="_blank">http://postgis.net</a><br>
<div>
<div><br><br>-----Original Message-----<br>From: <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>]
On Behalf Of Sandro Santilli<br>Sent: Thursday, November 07, 2013 4:57
PM<br>To: PostGIS Users Discussion<br>Subject: Re: [postgis-users] Error
updating PostGIS<br><br>On Thu, Nov 07, 2013 at 03:47:52PM -0600, Armando
Pardo Zepeda wrote:<br>> Please, I need help to update a database with a
postgis version of<br>> "POSTGIS="2.0.0alpha7SVN" to PostGIS 2.1.0 in
Debian Wheezy<br>><br>> I already tried with:<br>> ALTER EXTENSION
postgis UPDATE TO "2.1.0" but it returns the error<br>>
message:<br>> ERROR: extension "postgis" has no update path from
version<br>> "2.0.0alpha7SVN" to version "2.1.0"<br><br>See where you can
go to from "2.0.0*":<br>ls `pg_config
--sharedir`/extension/postgis--2.0.0*<br><br>--strk;<br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br><br>_______________________________________________<br>postgis-users
mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></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" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>