Edit

Share via

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

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.

    Screenshot that shows the Server parameters menu option.

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

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

  4. Select Save.

    Screenshot that shows the Save button in the Server parameters page.

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

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

Related content

  • Last updated on