You have to use pg_dump version 8.3.2 to backup your database,e.g. the
same version of your source database. To restore, use the Perl script
and postgis.sql given with Postgis 2.0.4. This script calls pg_dump
command. It must be pg_dump version 9.2.4, e.g. your destination
database version. Use "pg_dump --version" to know the version of your
command.
You seem use 2 differents versions of PostgreSQL and PostGIS on the same
computer. To get a particular version of a command, type the whole path
of the command.
Regard
Sylvain Racine
Le 2013-07-04 10:07, Marcos Cano a écrit :
what version of pg_dump should i use?... i tried the 8..3.2 and i
think it works, but trying the suggested one, wich is the latest
(9.2.4) seems just to not work properly because it does not dump my
entire database (i assume is because of the mismatch of postgis versions)
On Wed, Jul 3, 2013 at 12:00 PM, Paragon Corporation <l...@pcorp.us
<mailto:l...@pcorp.us>> wrote:
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-boun...@lists.osgeo.org
<mailto:postgis-users-boun...@lists.osgeo.org>
[mailto:postgis-users-boun...@lists.osgeo.org
<mailto:postgis-users-boun...@lists.osgeo.org>] *On Behalf Of
*Marcos Cano
*Sent:* Wednesday, July 03, 2013 10:43 AM
*To:* postgis-users@lists.osgeo.org
<mailto:postgis-users@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 <http://postgis_restore.pl>)
do you think it will work?
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org>
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
