Postgres Extensions on Microsoft Azure

I was having trouble installing extensions as an Admin on my Postgres database hosted on Microsoft Azure, and searching for the answer proved rather hard.

I was creating a standard Extension:

AzureTest=> CREATE EXTENSION pg_trgm;

And getting the following message:

ERROR: extension “pg_trgm” is not allow-listed for “azure_pg_admin” users in Azure Database for PostgreSQL
HINT: to see the full allow list of extensions, please run: “show azure.extensions;”

So what gives? Well, as a managed database you just don’t get super-user access to your resource. You need to configure the extensions you want access to in the Azure Portal under ‘Server Parameters’:

Source: https://docs.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions