[postgis-users] postgres and postgis upgrade

[Marcos Cano]

well i guess while installing and making the postgis i installed it against
the 9.2.4  (with this : "./configure
--with-pgconfig=/usr/local/pgsql9.2.4/bin/pg_config" )

the postgis.sql you mention is to create a spatially enabled database? or
is it part of the restore process?

and yes im using the full path to the command to do everything.

thank you very much i really appreciate it


On Thu, Jul 4, 2013 at 9:51 AM, Racine, Sylvain <syracine at sympatico.ca>wrote:

>  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 <lr at 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-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?
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130704/56638e0d/attachment.html>