[postgis-users] Upgrade Postgis 1.4 to 2.0

[Paragon Corporation]

David,

box3d_extent wasn't included in legacy because its an internal type not
meant for direct use.

Regarding your issue with restore, strk can look into that one.  I would
suggest putting in a ticket for it.
http://trac.osgeo.org/postgis/newticket
as it sound like it might be a bug in the restore script.

There is another way you can try updating:
1) create new spatial database as you have been.  But instead of CREAE
EXTENSION

use the regular script path. and of course install legacy.sql 

2) restore your backup on top.
3) run the postgis_upgrade_20_minor.sql
rtpostgis_upgrade_20_minor.sql

4) Then do 

CREATE EXTENSION postgis FROM 'unpackaged';


I unfortunately don't have a 1.4 to test, but that should work.  Just ignore
any errors you get during restore.

Hope that helps,
Regina
http://www.postgis.us

 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of david.peyrieres
> Sent: Monday, May 14, 2012 4:22 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Upgrade Postgis 1.4 to 2.0
> 
> 
> 
> Hello all.
> I'm a newbie with PostGIS and I'm making my firsts upgrades 
> of Postgres databases and I meet some problems during upgrades.
> My database is on a Postgres 8.3 with PostGis 1.4 and I want 
> to deploy and upgrade it on another server with Postgres 
> 9.1.3 and  Postgis 1.5 or Postgis 2.0 (I don't succeed with 
> 1.5.3 last month ...).
> 
> Actually I work with Postgis 2.0
> 
> I've followed the instructions given in the documentation:
> 
> - compilations and installations of PROJ+GEOS+Postgis.
> 
> - I did an export of the older database with pg_dump and -Fc option
> 
> - I created a new database in which I created postgis 
> extension with psql -f ................... postgis.sql
> 
> As I try to upgrade a very old release of PostGIS and as 
> describe in documentation, I exec the script* legacy.sql***
> 
> - After that I ran a postgis_restore.pl with this syntax
>               ./postgis_restore.pl  export_FC_mybase.dmp | 
> psql -p 5433 -d tata 2>/tmp/resimport
> 
> 
> Unfortunately I got this error message :
> 
> ERROR: type < box3d_extent > does not exists
> 
> 
> 
> I think it's an old type of data ? How to resolve it ? Change 
> appl code 
> ? Is it a miss in legacy.sql ?
> Thanks, David.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>