Request to Enable PostGIS Extension on Azure PostgreSQL Server

Question

Request to Enable PostGIS Extension on Azure PostgreSQL Server

tugce tay 20

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

SSingh-MSFT 16,461 Reputation points Moderator

2024-08-28T06:18:43.5933333+00:00

Hi tugce tay •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer accepted by question author

0 additional answers

Your answer

SSingh-MSFT 16,461 Reputation points Moderator

2024-08-28T06:18:43.5933333+00:00

Hi tugce tay •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer 1

SSingh-MSFT 16,461 Moderator

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

Pingal Krishna Nayak 10 Reputation points

2025-11-06T14:42:18.1633333+00:00

I am trying to Enable POSTGIS Azure Extension through Azure Portal, but the menu options have been updated it does not have a server parameter anymore. Could you please guide me how can we achieve it from portal now.
Pingal Krishna Nayak 10 Reputation points

2025-11-06T14:44:26.56+00:00

Hello, SSingh I am trying to Enable POSTGIS Azure Extension through Azure Portal, but the menu options have been updated it does not have a server parameter anymore. Could you please guide me how can we achieve it from portal now.
Shilpesh Nitnaware 0 Reputation points

2025-11-07T19:50:26.61+00:00

You cannot perform this action anymore from portal. You need to use tableplus tool on a VM that is on same network as the DB and using the admin username and passowrd connect to the DB. Once connected, run SELECT create_extension('postgis'); and this will enable the extension. https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/reference-extensions#use-postgresql-extensions

Share via

Request to Enable PostGIS Extension on Azure PostgreSQL Server

0 additional answers

Your answer