[postgis-users] Error updating PostGIS

[Armando Pardo Zepeda]

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/b3bf28db/attachment.html>