Set the value of one or more server parameters

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides step-by-step instructions to set the value of one or more server parameters of an Azure Database for PostgreSQL flexible server.

Steps to set the value of one or more server parameters

Portal

Using the Azure portal:

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

2. In the resource menu, under Settings, select Server parameters.

   

3. Locate the read-write parameters whose current values you want to change, and set them to the new desired values.

   

4. Observe that an informational message indicates how many server parameter changes aren't saved yet, and select Save.

   

5. If the column Parameter type for any of the parameters changed is equal to Static, the server requires a restart for the changes to take effect. In that case, a dialog pops up so that you can select if you want to:

   • Save and Restart: In case you want to persist all changes made to all parameters whose values were modified, and immediately after restart the server for any changes to static parameters to take effect.
   • Save only: In case you want to persist all changes made to all parameters whose set values changed, but want to defer the server restart to a later time. Until you don't complete the server restart action, changes made to any static server parameters don't take effect.
   • Cancel: To not implement any changes yet.

   

CLI

You can set the value of a server parameter via the az postgres flexible-server parameter set command.

az postgres flexible-server parameter set --resource-group <resource_group> --server-name <server> --source user-override --name <parameter> --value <value>

And you can use the following script to conditionally restart the server, if any of the parameters changed require a restart for the change to take effect:

parameters_requiring_restart=$(az postgres flexible-server parameter list --resource-group <resource_group> --server-name <server> --query "[?isConfigPendingRestart==\`true\`] | length(@)")

if [ "$parameters_requiring_restart" -gt 0 ]; then
  az postgres flexible-server restart --resource-group <resource_group> --name <server>
fi

Related contents

• List all server parameters.
• List server parameters with modified values.
• List read-write static server parameters.
• List read-write dynamic server parameters.
• List read-only server parameters.
• Revert one server parameter to its default.
• Revert all server parameters to their default.