Load libraries in Azure Database for PostgreSQL flexible server

The server configuration parameter shared_preload_libraries determines which libraries load when an Azure Database for PostgreSQL flexible server starts. You must use this parameter to load any libraries that use shared memory. If you need to add your extension to the shared preload libraries, follow these steps:

Steps to load libraries

Use the Azure portal:

  1. Select your Azure Database for PostgreSQL flexible server.

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

  3. Add the libraries that you want to include in the value of shared_preload_libraries.

  4. Select Save.

  5. Because shared_preload_libraries is a static parameter, it requires a server restart for the changes to take effect.