Update extension PostgreSQL flexible server

Question

I am running PostgreSQL 13.5 on Azure Database for PostgreSQL flexible server and would like to update my extension PostGIS from version 3.1.1 to 3.2.0. On the official Microsoft website I can see they added support for version 3.2.0 link. However, I don't know how to actually update the extension.

Is there somewhere an description how to update the extension? Or can someone explain what the steps are to update the extension?

I tried to run the following:

ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();

But it doesn't work. I checked if there was a target called 3.2.0 it doesn't show:

SELECT * FROM pg_extension_update_paths('postgis') WHERE source='3.1.1' ORDER BY target;

Answer 1

Hi, @Zitman, PA (Pieter) Welcome to the Microsoft Q&A forum, Thanks for posting your question.
First, not sure why you are still running an older version. we should be at version 13.7, second as you can't see the target version 3.2.0 and you can confirm from this too "select * from pg_available_extension_versions where name = 'postgis';"

Please let me know what you see.

Regards
Geetha