Opened 7 months ago

Closed 7 months ago

Last modified 7 months ago

#5592 closed task (worksforme)

Postgres Upgrade Compatibility with PostGIS Extension

Reported by: rama Owned by: pramsey
Priority: medium Milestone: PostGIS 3.4.1
Component: build Version: 3.3.x
Keywords: PostgreSQL V16 Upgrade Dependency Cc: rama

Description (last modified by 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?

Change History (3)

comment:1 by rama, 7 months ago

Description: modified (diff)

comment:2 by robe, 7 months ago

Resolution: worksforme
Status: newclosed

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

Last edited 7 months ago by robe (previous) (diff)

comment:3 by robe, 7 months ago

Component: postgisbuild/upgrade/install
Note: See TracTickets for help on using tickets.