[postgis-users] Error updating PostGIS

[Paragon Corporation]

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131107/e08a16d6/attachment.html>