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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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: [email protected] [mailto:[email protected]] 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 [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
