[postgis-devel] Postgis 3.3 extension upgrade on AWS RDS Postgres 13.3

Sandro Santilli strk at kbt.io
Wed Feb 16 05:26:52 PST 2022


On Tue, Feb 15, 2022 at 12:55:53PM -0500, Regina Obe wrote:
> > 
> > In 3.3 I had `postgis_extensions_upgrade()` do the UPDATE to pg_extension.
> > If that's going to error out, under AWS, while the previous approach worked,
> > we'll probably want to revert that change.
> 
> I suspect it will work, but I'll confer with Amazon RDS staff.

Thanks.

> CREATE EXTENSION / ALTER EXTENSION is run by a real super user rdsadmin or some such thing.
> For the brief period that people run those commands they are doing it as a real super user.

The postgis_extensions_upgrade() would run OUTSIDE of alter extension

--strk;


More information about the postgis-devel mailing list