Update extension PostgreSQL flexible server

Zitman, PA (Pieter) 1 Reputation point
2022-11-29T12:07:24.087+00:00

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;

265208-image.png

Azure Database for PostgreSQL
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
    2022-11-30T20:28:57.757+00:00

    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