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:[email protected]] On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Monday, October 22, 2018 12:47 PM To: PostGIS Users Discussion <[email protected]> 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 <[email protected] <mailto:[email protected]> >: 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 [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users -- Darafei Praliaskouski Support me: http://patreon.com/komzpa
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
