[postgis-users] Upgrading from PostgreSQL 8.0 with PostGIS 0.9 to PostgreSQL 8.1 with PostGIS 1.0

[Mario Servin]

Hi everybody,
I failed completely to restore my data from a PostgreSQL 8.0 with PostGIS
0.9 to PostgreSQL 8.1 with PostGIS 1.0. I have both versions of PosgreSQL
running in Windows. I follow instructions in PostGIS docs from the
PostgreSQL installation for upgrading. The postgis_restore.pl could create
the dump list and also the dump ascii but then gives an error because it
does not allow me to write down the password at the next step. As I know
something about Perl I tried to modify the script without success.
Additionally, I still have the results from the old shp2pgsql and so I tried
to insert the data form psql using \i mysqlinsertionscript.sql. Tables are
created ok, but geom columns results in meaningless characters where it is
supossed to be something like "POINT (-66.046532 -21.951437)" for example.
Can anybody help me?.
Regards,
            Mario Servin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060120/23724ac8/attachment.html>