Failed to upgrade postgis to version 3.4

Aiven Community
1

I wants to upgrade postgis from 3.2 to 3.4 by following command:
ALTER EXTENSION postgis UPDATE TO ‘3.4’;
However, I got error ERROR: extension “postgis” has no update path from version “3.2.4” to version “3.4” .
How can I upgrade my postgis? Thanks

1 Like
2

Hi @cs1 did you try upgrading to 3.3 first? I’d suggest trying to reach 3.4 not in 1 step.

3

Hi @Floor Thanks for replying.
Yes, I have tried to upgrade to 3.3, the same error occurred. Seems aiven don’t allow us to upgrade.

1 Like
4

Hi @cs1 ! I asked the team and they came back with the following:
“We don’t provide postgis 3.4.0, only on (unreleased) PG16. postgis 3.3 is available on PG15 so if they have an earlier version they would need to upgrade PG as well.”

5

Hi @Floor, thanks for your reply. My PG version is PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.2.1 20231011 (Red Hat 13.2.1-4), 64-bit.
I run following code to upgrade postgis version to 3.3
ALTER EXTENSION postgis UPDATE TO ‘3.3.0’;
It failed with error: ERROR: extension “postgis” has no update path from version “3.2.4” to version “3.3.0”

6

To upgrade PostGIS from version 3.2.4 to 3.4, you may need to follow an intermediate step:

1:
ALTER EXTENSION postgis UPDATE TO ‘3.X’;
2: Replace ‘3.X’ with a version between 3.2.4 and 3.4. according to your need

3: Verify the upgrade:

SELECT postgis_version();

Best Regard
Danish Hafeez | QA Assistant
https://www.ictinnovations.com