Request to Enable PostGIS Extension on Azure PostgreSQL Server

Question

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;"

Answer 1

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:

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

Thanks