<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Arial"><br>
<br>
Hello all.<br>
I'm a newbie with PostGIS and I'm making my firsts upgrades of Postgres
databases and I meet some problems during upgrades.<br>
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 </font><font face="Arial">Postgis 2.0 </font><font face="Arial">(I
don't succeed with 1.5.3 last month ...).<br>
<br>
Actually I work with Postgis 2.0<br>
<br>
I've followed the instructions given in the documentation:<br>
<br>
- compilations and installations of PROJ+GEOS+Postgis.<br>
<br>
- I did an export of the older database with pg_dump and -Fc option<br>
<br>
- I created a new database in which I created postgis extension with
psql -f ................... postgis.sql<br>
<br>
As I try to upgrade a very old release of PostGIS and as describe in
documentation, I exec the script<strong><font size="2"> legacy.sql</font></strong></font><strong><font
size="2"><span style="font-weight: normal;"></span></font></strong><br>
<font face="Arial"><br>
- After that I ran a postgis_restore.pl with this syntax<br>
./postgis_restore.pl export_FC_mybase.dmp | psql -p 5433
-d tata 2>/tmp/resimport<br>
<br>
<br>
Unfortunately I got this error message :<br>
</font>
<p style="margin-bottom: 0cm; font-weight: normal;"><font size="2">ERROR:
type « box3d_extent » does not exists<br>
</font></p>
<br>
<br>
<font face="Arial">I think it's an old type of data ? How to resolve it
? Change app code ? Is it a miss in legacy.sql ?<br>
Thanks, David.<br>
</font><font face="Arial"><br>
<br>
<br>
<br>
</font>
<div class="moz-signature"><br>
</div>
</body>
</html>