[postgis-users] Error updating PostGIS

[Armando Pardo Zepeda]

Thanks for help, I was renaming the wrong file.
Finaly i ran:
"cp postgis--2.0.0alpha6--2.0.0.sql postgis--2.0.0alpha7SVN--2.0.0.sql"
Then i updated to 2.0.0 and later from 2.0.0 to 2.1.0 successfully.


2013/11/7 Paragon Corporation <lr at pcorp.us>

>  Armando,
> 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.
>
>
>
> use the file called *postgis--2.0.0--2.1.0.sql*
>
> and call it  *postgis--2.0.0alpha7SVN.sql--2.1.0.sql*
>
>
> You might still run into errors (but they will be different) .
>
>
> pramsey,
>
> 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.
>
> Thanks,
> Regina
>
>
>  ------------------------------
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Armando Pardo Zepeda
> *Sent:* Thursday, November 07, 2013 6:10 PM
>
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Error updating PostGIS
>
>  Thanks for reply. The "pg_config --sharedir" is:
> /usr/share/postgresql/9.1 directory.
> All files of the postGIS versions I installed are there (2.0.0alpha7SVN
> and 2.1.0).
>
> I tried renaming the file  postgis--2.1.0.sql to
> postgis--2.0.0alpha7SVN.sql but I get the same error message.
>
> The database is big and I wish do the upgrade of postGIS without do backup
> and restore if it is possible.
>
>
> 2013/11/7 Paragon Corporation <lr at pcorp.us>
>
>> The safest is to do a backup and restore.  The restoration will use the
>> newest postgis you have unless you pre-install a new db with CREATE
>> EXTENSION postgis VERSION "something"
>>
>>
>> Normally I'd advice to just copy the postgis--2.0.0-2.1.0.sql  to
>> postgis--2.0.0alpha7SVN-2.1.0.sql and repeat your ALTER EXTENSION
>>
>> but I recall some major breaking changes (last minute ondisk I think)
>> between the 2.0.0 beta1 and 2.0.0 beta2 that would necessitate a dump
>> restore otherwise you'd run into issues down the line.
>>
>> Hope that helps,
>> Regina
>> http://www.postgis.us
>> http://postgis.net
>>
>>
>> -----Original Message-----
>> From: postgis-users-bounces at lists.osgeo.org
>> [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Sandro
>> Santilli
>> Sent: Thursday, November 07, 2013 4:57 PM
>> To: PostGIS Users Discussion
>> Subject: Re: [postgis-users] Error updating PostGIS
>>
>> On Thu, Nov 07, 2013 at 03:47:52PM -0600, Armando Pardo Zepeda wrote:
>> > Please, I need help to update a database with a postgis version of
>> > "POSTGIS="2.0.0alpha7SVN" to PostGIS 2.1.0 in Debian Wheezy
>> >
>> > I already tried with:
>> > ALTER EXTENSION postgis  UPDATE TO "2.1.0"  but it returns the error
>> > message:
>> > ERROR:  extension "postgis" has no update path from version
>> > "2.0.0alpha7SVN" to version "2.1.0"
>>
>> See where you can go to from "2.0.0*":
>> ls `pg_config --sharedir`/extension/postgis--2.0.0*
>>
>> --strk;
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131108/21e455f9/attachment.html>