Load libraries

shared_preload_libraries is a server configuration parameter that determines which libraries have to be loaded when an Azure Database for PostgreSQL flexible server instance starts. Any libraries that use shared memory must be loaded via this parameter. If your extension needs to be added to the shared preload libraries, follow these steps:

Steps to load libraries

Portal

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server instance.

2. From the resource menu, under Settings section, select Server parameters.

   

3. Include the libraries that you want to add in the value of shared_preload_libraries.

   

4. Select Save.

   

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

   

CLI

You can set shared_preload_libraries using the CLI parameter set command.

az postgres flexible-server parameter set \
  --resource-group <resource_group> \
  --server-name <server> \
  --name shared_preload_libraries \
  --value <extension_name>,<extension_name>

And can restart the server using the CLI restart command.

az postgres flexible-server restart \
  --resource-group <resource_group> \
  --name <server>

Related content

• Extensions and modules
• Special considerations with extensions and modules
• List of extensions and modules by name
• List of extensions and modules by version of PostgreSQL