[postgis-users] Upgrading PostGIS

[Regina Obe]

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-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>
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 <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?

 

Thanks,

Clifford


 

-- 

@osm_washington

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> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

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