Request to Enable PostGIS Extension on Azure PostgreSQL Server

tugce tay 0 Reputation points
2024-08-25T05:18:06.2366667+00:00

I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error:

ERROR: extension "postgis" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

HINT: to see the full list of allowed extensions, please run: "show azure.extensions;"

Azure SQL Database
Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,336 Reputation points
    2024-08-26T13:38:15.77+00:00

    Hi tugce tay •,

    Welcome to Microsoft Q&A forum.

    As I understand, for Postgis extension you are getting error: ERROR: extension "postgis" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL.

    Go to server parameter and search for azure extensions, select POSTGIS and save it as shown below:

    enter image description here

    After this try to perform your operation and see if that helps.

    Thanks

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.