Allan, So that might be issue if you jump from 11 to 13 in between Postgis is missing you can open AWS case and confirm.
Fix is you upgrade to 12 do Postgis upgrade and then do PG 13 upgrade and Postgis Upgrade again . Issue is how they maintain all Postgis version prior they not allow skip in between version I mostly use Aurora so if they allowing this on RDS might have started recently, it will be good if they control Postgis upgrade or have some fix of issue you facing. If you in urgency do upgrade the steps I mentioned should work. Upgrade to 12 and do Postgis Upgrade (you can bypass analyze step) and start upgrade to 13 and do Postgis upgrade and do post upgrade steps analyze etc … issue is Postgis 2.52 need to upgrade to Postgis 3.0 and then you can upgrade to Postgis 3.2 there is not direct jump from Postgis 2.5 to Postgis 3.2 hopefully they can handle if they allowing PG upgrades from11 to 13 directly they should handle this too. Thanks Raj On Mon, Feb 14, 2022 at 6:26 PM Allan Chase <allan.ch...@bluestaq.com> wrote: > According to Upgrading the PostgreSQL DB engine for Amazon RDS - Amazon > Relational Database Service > <https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html>, > one can upgrade from 11.12 right to 13.3. > > > > Allan Chase > > Data Engineer > > > > *From:* Raj Talati <rajtal...@gmail.com> > *Sent:* Monday, February 14, 2022 4:08 PM > *To:* Allan Chase <allan.ch...@bluestaq.com>; PostGIS Users Discussion < > postgis-users@lists.osgeo.org> > *Subject:* [External] Re: [postgis-users] Postgis 3.0.3 extension for AWS > RDS Postgres 13.3 > > > > ************************************************************************** > ATTENTION: External email > Please verify the sender before opening attachments or clicking links. > ************************************************************************** > > If this AWS RDS you cannot upgrade directly from 11.x to 13.x . You will > need to upgrade to 12.x and if you did like upgraded 11.x to 12.x and the. > Upgraded fro 12.x to 13.3 then when you upgraded from 11.x to 12.x you need > to upgrade Postgis too as AWS as that should allow you to upgrade postgis > and then when you upgrade Postgres to 13 you should able to upgrade Postgis > too. If we bypass Postgis upgrade while going from 11-> 12 and just so > while doing 12->13 you will face this issue . > > > > Hope this helps. > > > > On Mon, Feb 14, 2022 at 5:40 PM Sandro Santilli <s...@kbt.io> wrote: > > On Mon, Feb 14, 2022 at 03:33:29PM -0500, Regina Obe wrote: > > > 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'; > > Allan: please let us know if AWS RDS allows or not the above > UPDATE, as we are planning to use that construct for > the postgis_extensions_upgrade() function in PostGIS-3.3.0 > > --strk; > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
