Postgres Upgrade Compatibility with PostGIS Extension

[rama]

We have the Postgis2.5.0 extension running on the PostgreSQL version 11.0. We could upgrade to 11.21 and 3.3.3 respectively

We want to upgrade to the PostgreSQL version 16. We don't have a common PostGIS version between 11 and 16.

Based on PostGIS documentation, the PostGIS version must match the source and target for the upgrade process. Could you please confirm if we have any other option present to Jump from Postgres version 11 to 16 with PostGIS?

[robe]

Since PostGIS 3+, you should be able to easily pg_upgrade from a 3.* to a 3.*

That said, to use pg_upgrade to upgrade you to 3.4. Do this

1) Upgrade your pg 11 from 2.5 to 3.3

2) Then that said install PG16 PostGIS 3.4.0

Then you should have no issue doing pg_uprade from 11 3.3 to 16 3.4

Once you have PG16 upgraded, run

SELECT postgis_extensions_upgrade();

I should also add, if you don't use pg_upgrade and just doing pg_dump / pg_restore

You shouldn't have any issue, pg_dump your PG 11 3.3 and restoring on pg_restore on a PG 16 with 3.4

then running the extensions upgrade function