As Raj mentioned, it’s backward compatible.
The main thing that changed between 2.5.2 and 3 is that the postgis_raster extension is split so make sure you follow the additional steps for that as it unbundles the raster functions from PostGIS and rebundles them. I forget how we got around the issue that PG13 no longer allows from unpackaged. I think we did somehow (strk do you remember? Or is that still an issue). Also I think 2.5.2 maybe not have the fixes we put in postgis_extensions_upgrade(); So might have to do after your upgrade ALTER EXTENSION postgis UPDATE; -- need to run this twice cause first time unbundles postgis_raster, and second rebundles it. -- http://postgis.net/docs/manual-3.0/PostGIS_Extensions_Upgrade.html SELECT postgis_extensions_upgrade(); SELECT postgis_extensions_upgrade(); Once postgis_raster has been rebundled into it’s own extension, then you can do: DROP EXTENSION postgis_raster; If you are not using raster functionality. From: postgis-users [mailto:[email protected]] On Behalf Of Raj Talati Sent: Thursday, January 6, 2022 2:12 PM To: PostGIS Users Discussion <[email protected]> Subject: Re: [postgis-users] AWS RDS postgis compatibility Allan, There is no need for extra stuff in upgrade process. Once upgrade of Postgres is done (I would recommend to upgrade to 13.4 will bring postgis 3.1 which helps better still your choice )once upgrade is done you need to upgrade the postgis extension. We not had any backward compatibility issues still as always test out on non prod environments. On Thu, Jan 6, 2022 at 1:25 PM Allan Chase <[email protected] <mailto:[email protected]> > wrote: Greetings and salutations, I currently have an RDS database instance with PostgreSQL under the hood and we use postgis 2.5.2. My question is, I need to upgrade PostgreSQL to 13.3 which comes with the postgis 3.0.3 extension, are there any special considerations that I need to make when upgrading to the new database version with regards to this extension? One of our developers seemed to indicate that there may be some extra considerations or steps involved. In a nutshell, is it backwards compatible or do I need to export the data (containing spatial columns), perform the upgrade then re-import the data back in? --Allan _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
