Create extensions for Azure HorizonDB (Preview)

Before creating extensions in an Azure HorizonDB cluster, you must allowlist them.

Steps to create extensions

1. Allow extensions in Azure HorizonDB (Preview) 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:

   • Allow extensions in Azure HorizonDB (Preview) 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>;
   

   • Allow extensions in Azure HorizonDB (Preview) 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 HorizonDB are open-source licensed code. We don't offer any third-party extensions or extension versions with premium or proprietary licensing models.

Your Azure HorizonDB 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 HorizonDB instance. Extensions not included in the lists referred before aren't supported on your Azure HorizonDB instance.

Related content

• Extensions and modules in Azure HorizonDB (Preview)
• Considerations with the use of extensions and modules in Azure HorizonDB (Preview)
• List of extensions and modules by name in Azure HorizonDB (Preview)
• List of extensions and modules by version of PostgreSQL in Azure HorizonDB (Preview)