Hi to all,I'm new in this mailing list.In these days I have some problems
upgrading some databases from 1.3.2 postgis versionto new 2.0.1 version.I read
some information pages as [1], [2], [3], and others...This is the situation:The
postgresql database 8.2.6 run in linux debian squeeze server with postgis
1.3.2. {old}I have inside the database somthing like 20 spatial db.Now, I would
like to upgrade the server, so I installed, on compiling way, the
postgresql9.1.4 on a different port. The two database run ok concurrently. On
postgresql 9.1.4I installed, compiling, postgis 2.0.1.That is still ok.The
problem is how to migrate the data.I started with pg_dumpall, but the first
problme was the different encoding of the two clusters,so i used pg_dump with
-E UTF8 for each db. I think the dump file are ok.The further step, as you
know, invole the restore, so my problem start.At this time i discovered that
postgis 2 has geometry_columns as view and not as table in public schema,and
may be this is one of the most problem I have, in fact when I tried to import
data with psql,something went wrong, and only the table in the others database
schema has imported.I tried also with pg_dump with -Fc option, but i got the
same problem.So i tried both run legacy.sql on the new database created and
postgis_restore.pl,but the last one give me:
postgres@servergis:~$ perl
/usr/local/pgsql914/share/contrib/postgis-2.0/postgis_restore.pl
"/home/postgres/bdng_261.sql" Converting /home/postgres/bdng_261.sql to ASCII
on stdout... Reading list of functions to ignore... Writing manifest of
things to read from dump file...pg_restore: [archiviatore] versione (1.12) non
supportata nell' header del
file/usr/local/pgsql914/share/contrib/postgis-2.0/postgis_restore.pl:
pg_restore returned an error
For example in the [2] he suggest don't use the public schema for the data, so
i'm wondering ifi have to move the data from public schema to another one then
make pg_dump end restore,or there is a shorter way to get the result?
Could someone suggest me a way to restore the data correctly?
Best regards
Eugenio
[1] http://postgis.refractions.net/docs/postgis_installation.html#upgrading[2]
http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html[3]
http://www.postgresql.org/docs/9.0/static/migration.html
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
