[postgis-users] Upgrade Postgis 1.4 to 2.0

[Sandro Santilli]

On Mon, May 14, 2012 at 10:21:56AM +0200, david.peyrieres wrote:
> 
> 
> 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 ?

Check /tmp/resimport to see what's triggering the error.
If it's an old postgis function you don't need to worry (other than
maybe instructing postgis_restore.pl about the need to also skip
that function).


--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'