Azure Database for PostgreSQL - Flexible Server adds support for concept of extension allowlists for newly created Flexible servers to provide database administrators more control over usage of extensions.
Azure Database for PostgreSQL - Flexible Server supports over 50 PostgreSQL extensions. Extensions expand on the functionality provided by the PostgreSQL engine. However, for regulatory or compliance purposes, some organizations would like to be able to specify approved extensions. With extension allow-list setup by server parameters, you can specify which specific extensions can be installed on a PostgreSQL DB instance.
Using the Azure portal:
- Select your Azure Database for PostgreSQL - Flexible Server.
- On the sidebar, select Server Parameters.
- Search for the azure.extensions parameter.
- Select extensions you wish to allow-list.
Figure 1. Azure.extensions server parameters that can be used to allow-list extensions in Azure portal.
After extensions are allow-listed, these must be installed in your database before you can use them. To install a particular extension, you should run the CREATE EXTENSION command. This command loads the packaged objects into your database.
For more information about Azure Database for PostgreSQL and its support for extensions see - Azure Database for PostgreSQL - Flexible Server | Microsoft Docs
We’re always eager to get your feedback, so please reach out via email to Ask Azure DB for PostgreSQL.
