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------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
