Oops didn’t noticed you are on Fedora – The below should still work but the paths are different.
I recall the paths for Centos / Fedora being /var/lib/pgsql/13 but you should double-check. But anyway the main objective of the below is to have the -2.5 names point to the -3 names since the -3 is downward compatible with 2.5 From: Regina Obe [mailto:l...@pcorp.us] Sent: Thursday, December 17, 2020 5:06 PM To: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org> Subject: RE: [postgis-users] Upgrading PostGIS Clifford, I think this may be referenced in Darafei’s notes but couldn’t find the version for upgrade from 2.5 to 3/3.1 On old make sure you are running latest PostGIS 2.5, because there are some view changes I think pre- 2.5.3 that will prevent upgrade to 13. Then make sure to run SELECT postgis_extensions_upgrade(); On the new server, you would do this sudo ln -sf /usr/lib/postgresql/13/lib/postgis-2.5.so /usr/lib/postgresql/13/lib/postgis-3.so sudo ln -sf /usr/lib/postgresql/13/lib/rtpostgis-2.5.so /usr/lib/postgresql/13/lib/raster_postgis-3.so sudo ln -sf /usr/lib/postgresql/13/lib/postgis_toplogy-2.5.so /usr/lib/postgresql/13/lib/postgis_topology-3.so Then once upgraded in your new database run SELECT postgis_extensions_upgrade(); After that you can delete the *postgis*-2.5.so you symlinked. From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Darafei "Kom?pa" Praliaskouski Sent: Thursday, December 17, 2020 4:18 PM To: PostGIS Users Discussion <postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> > Subject: Re: [postgis-users] Upgrading PostGIS Hi, Here is a gist I use to put notes of all my upgrades: https://gist.github.com/Komzpa/994d5aaf340067ccec0e чц, 17 сне 2020, 23:46 карыстальнік Clifford Snow <cliff...@snowandsnow.us <mailto:cliff...@snowandsnow.us> > напісаў: I want to upgrade Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 on a Fedora Workstation. Is it possible? I thought that I could upgrade postgresql from 11 to 13 then just add postgis, but pg_upgrade apparently wants postgis 2.5. 2.5 isn't available for postgresql 13. Another thought was to upgrade to PostGIS 31 on Postgresql 11 first - but dnf won't let me install PostGIS 3.1 without first removing 2.5. Afraid that I'd screw up the databases I decide not to go that route. If you've upgraded from Postgresql from 11 to 13 and PostGIS from 2.5 to 3.1 how did you do it? Thanks, Clifford -- @osm_washington www.snowandsnow.us <https://www.snowandsnow.us> OpenStreetMap: Maps with a human touch _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
