[postgis-users] Upgrading PostGIS

Regina Obe lr at pcorp.us
Thu Dec 17 14:09:45 PST 2020

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:lr at pcorp.us] 
Sent: Thursday, December 17, 2020 5:06 PM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
Subject: RE: [postgis-users] Upgrading PostGIS




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-bounces at lists.osgeo.org] On Behalf Of Darafei "Kom?pa" Praliaskouski
Sent: Thursday, December 17, 2020 4:18 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> >
Subject: Re: [postgis-users] Upgrading PostGIS




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 <clifford at snowandsnow.us <mailto:clifford at 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?







www.snowandsnow.us <https://www.snowandsnow.us> 

OpenStreetMap: Maps with a human touch

postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 

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

More information about the postgis-users mailing list