<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16721"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013>Armando,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013>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 size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013>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 size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013>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 size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=066193704-08112013></SPAN></FONT> </DIV>
<DIV><SPAN class=066193704-08112013></SPAN><FONT color=#0000ff size=2
face=Arial>You might still run into errors<SPAN
class=066193704-08112013> (but they will be
different)</SPAN> .</FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2
face=Arial>pramsey,</FONT></SPAN></DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2 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 class=066193704-08112013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=066193704-08112013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><BR></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Armando Pardo
Zepeda<BR><B>Sent:</B> Thursday, November 07, 2013 6:10 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Error updating
PostGIS<BR></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 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 class=HOEnZb>
<DIV class=h5><BR><BR>-----Original Message-----<BR>From: <A
href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</A><BR>[mailto:<A
href="mailto:postgis-users-bounces@lists.osgeo.org">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">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">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></BODY></HTML>