Edit

Load libraries

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

Using the Azure portal:

  1. Select your Azure Database for PostgreSQL flexible server.

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

    Screenshot showing the Parameters menu option.

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

    Screenshot showing how to select libraries to be loaded in memory when the server starts.

  4. Select Save.

    Screenshot that shows the Save button in the Parameters page.

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

    Screenshot of Parameters page, showing the dialog from which you can save changes and restart.

  6. A new deployment is launched to set the value of the shared_preload_libraries parameter on your Azure Database for PostgreSQL flexible server.

    Screenshot showing the deployment in progress to set the value of shared_preload_libraries parameter on your Azure Database for PostgreSQL flexible server.

  7. When the deployment completes, select Go to resource to go back to your Azure Database for PostgreSQL flexible server.

    Screenshot showing the deployment successfully completed to set the value of shared_preload_libraries parameter on your Azure Database for PostgreSQL flexible server.

Related content

  • Last updated on