Allow extensions

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. From the resource menu, under the Settings section, select Parameters.

   

3. Select the extensions that you want to allowlist from the ones available in the azure.extensions parameter.

   

4. Select Save.

   

5. A new deployment is launched to set the value of the azure.extensions parameter on your Azure Database for PostgreSQL flexible server.

   

6. When the deployment completes, select Go to resource to go back to your Azure Database for PostgreSQL flexible server.

   

Use the az postgres flexible-server parameter set command to add extensions to the allow list on your server.

az postgres flexible-server parameter set \
  --resource-group <resource_group> \
  --server-name <server> \
  --name azure.extensions \
  --value "<extension_name>,<extension_name>"