Load libraries

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

shared_preload_libraries is a server configuration parameter that determines which libraries have to be loaded when Azure Database for PostgreSQL flexible server 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 you wish to add in the value of shared_preload_libraries, and select Save.

   

4. Because shared_preload_librariesis 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 parameter set command.

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

Related content

• Allow extensions.
• Create extensions.
• Drop extensions.
• Update extensions.
• View installed extensions.