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

[Patrick Stout]

My database is small (< 200 MB) and pg_dump/restore appears to being
working correctly. I just wanted to make sure those errors during import
didn't break something I'm not seeing (yet).

Thanks for the help!

Patrick


On Mon, Oct 29, 2018 at 12:11 PM Regina Obe <lr at pcorp.us> wrote:

> 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>:
>
> 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
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> --
>
> Darafei Praliaskouski
> Support me: http://patreon.com/komzpa
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181029/88c808a6/attachment.html>