Edit

Share via

Create extensions

Before creating extensions in an Azure Database for PostgreSQL flexible server instance, you must allowlist them.

Steps to create extensions

  1. Allowlist the extension.

  2. If the extension requires it, also add it to shared_load_libraries.

  3. To create untrusted extensions, a user must be a member of the azure_pg_admin role. Any user with CREATE privilege can create any trusted extension listed in azure.extensions. This list can be retrieved by running SHOW azure.extensions;

  4. Run the CREATE EXTENSION command to create or install a particular extension. This command loads the packaged objects into your database.

    CREATE EXTENSION <extension>;

  5. Some extensions require other extensions to be created first, because they depend on objects distributed by those other extensions. It's the case, for example, of the pg_diskann extension, which has dependencies on the vector extension. To install such extensions, you can proceed in two ways:

    • Allowlist and run CREATE EXTENSION first on the extension on which it depends. Then, allowlist and run CREATE EXTENSION on the dependent extension.
    CREATE EXTENSION <depending_extension>;
CREATE EXTENSION <dependent_extension>;
    • Allowlist and run CREATE EXTENSION on the dependent extension only, but add the CASCADE clause, so that it automatically creates all extensions on which it depends.
    CREATE EXTENSION <dependent_extension> CASCADE;

Note

Third-party extensions offered for Azure Database for PostgreSQL are open-source licensed code. We don't offer any third-party extensions or extension versions with premium or proprietary licensing models.

Your Azure Database for PostgreSQL flexible server instance supports a subset of all existing PostgreSQL extensions, as listed in supported extensions by name or in supported extensions by version of PostgreSQL.

This information is also available by running SHOW azure.extensions;.

You can't bring your own extensions into an Azure Database for PostgreSQL flexible server instance. Extensions not included in the lists referred before aren't supported on your Azure Database for PostgreSQL flexible server instance.

Related content