|
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 app code ? Is it a miss in legacy.sql ? Thanks, David. |
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
