[postgis-users] PostGIS - Migration case from 9.3/2.1 to 10.5/2.5

[Regina Obe]

Unfortunately I don't think you can use the symlink approach to go from 2.1 – 2.5 because we took out functions between 2.1 and 2.2.

 

At least that is what I recall from memory.  I haven't retested recently.

 

If you installed PostGIS using extensions, the functions ARE NOT in the dump.

 

So you should be good to just backup the database and restore on your 10.5 that has  PostGIS 2.5 binary installed.  

The restore process will recreate the postgis extension and will use the 2.5 one if that's the last installed version on your 10.5.

 

Alternative would be if you can, upgrade your 9.3/2.1 -> 2.5 using   ALTER EXTENSION postgis UPDATE;

 

And then pg_upgrade over to PostgreSQL 10.5 +PostGIS 2.5

 

If your database is small (by small, I mean less than 10GB) and you only have one database, probably easier to just do a pg_dump  and then pg_restore.

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Darafei "Kom?pa" Praliaskouski
Sent: Monday, October 22, 2018 12:47 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] PostGIS - Migration case from 9.3/2.1 to 10.5/2.5

 

Hi,

 

I keep a gist with upgrading tldr:

https://gist.github.com/Komzpa/994d5aaf340067ccec0e 

You can notice most upgrades are similar and can be done by analogy.

 

Versions 2.1 and 2.5 have 5 years between them, so there are quite a lot of small changes. However, if you weren't using weird tricks, the update should be rather smooth.

 

You may want to read NEWS file, focusing on Breaking Changes entries, between version 2.1 and 2.5.

https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.0/NEWS 

 

 

пн, 22 окт. 2018 г. в 19:41, Daniel Boulerice <Boulerice_Daniel at cat.com <mailto:Boulerice_Daniel at cat.com> >:

Is there a document highlighting the caveats of migrating

 

*	From Postgres 9.3 + PostGIS 2.1
*	To Postgres 10.5 + PostGIS 2.5

 

I guess the best way is to migrate the data only because the functions included in the dump cause errors.

 

Caterpillar: Confidential Green

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 

Darafei Praliaskouski
Support me: http://patreon.com/komzpa

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181029/978a27f7/attachment.html>