[postgis-users] postgres and postgis upgrade
Paragon Corporation
lr at pcorp.us
Wed Jul 3 11:00:01 PDT 2013
Yes (custom dump of 8.3.2 + pgis, create new postgis 2.0.4 in 9.2.4 and
restore backup) is the recommended way. 9.2.4 + 1.5.8 are borderline
compatible so I would avoid that mix and if your ultimate goal is to go to
2.0, 1.5.8 requires a hard upgrade anyway so not worth the hassle.
_____
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Marcos Cano
Sent: Wednesday, July 03, 2013 10:43 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] postgres and postgis upgrade
So I'm trying to upgrade Postgres and postgis.. My current versions are
8.3.2 and 1.3 respectively. And trying to upgrade to postgis 2.0.4 and
Postgres 9.2.4
I've been trying a lot of options like:hard upgrade of postgis to 1.5.8 in
the Postgres 8.3 ( as I'm sure that version of postgis is compatible with
Postgres 8.3 and 9.2.4)
Then installing postgres 9.2.4 + postgis 1.5.8 and do a pg_upgrade and
finally do a hard upgrade of postgis to 2.0.4 in the postgres 9.2.4
installation. It seems to work until an error happened during the
pg_upgrade
Your installation contains the "name" data type in user tables. This data
type changed its internal alignment between your old and new clusters so
this cluster cannot currently be upgraded. You can remove the problem
tables and restart the upgrade.
So I tried another option but I don't know if this will work. Here's my
idea:
Do a custom dump of the DB in Postgres 8.3.2 + pgis 1.3 .
Install 9.2.4 with postgis 2.0.4
And do a restore with perl script included in the postgis binary folder
(perl utils/postgis_restore.pl)
do you think it will work?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130703/652601b1/attachment.html>
More information about the postgis-users
mailing list