[postgis-devel] [postgis-users] Postgis 3.0.3 extension for AWS RDS Postgres 13.3

[Regina Obe]

No don't do that, you'll destroy data.

Are you able to hold off?  I think Amazon should be releasing an update
soon.

If you can't wait, the workaround is below, but not sure it will work on AWS
RDS as updating system tables might be off limits.

UPDATE pg_extension SET extversion = 'ANY'
WHERE extname = 'postgis';


ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();



> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf Of Allan Chase
> Sent: Monday, February 14, 2022 3:21 PM
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>; 'PostGIS
> Development Discussion' <postgis-devel at lists.osgeo.org>
> Subject: [postgis-users] Postgis 3.0.3 extension for AWS RDS Postgres 13.3
> 
> Queston:
> 
> If there isn't a Postgis upgrade path when upgrading Postgres 11.12
(2.5.2) to
> 13.3 (3.0.3), can we just drop the extension, do the upgrade, then
re-create
> the extension in the new database?  I get an error message saying that it
> can't upgrade due to "no upgrade path" for 2.5.2 to 3.0.3.
> 
> Allan Chase
> Data Engineer
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users