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 <[email protected]> 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:[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]>: > > 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] > 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
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
