[postgis-users] Error updating PostGIS

[Paragon Corporation]

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