Set the value of one or more parameters

Using the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

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

   

3. Find the read-write parameters you want to change, and set them to the new values.

   

4. An informational message shows how many parameter changes aren't saved yet. Select Save.

   

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

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

   

Use the az postgres flexible-server parameter set command to set the value of a parameter.

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

You can use the following script to conditionally restart the server if any of the parameter changes 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