Revert one parameter to its default

Use the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

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

   

3. Select the Modified tab.

   

4. Find the read-write parameter that you want to revert to its default value. Select the ellipsis at the right end of the screen, and select Reset to default.

   

1. If the Parameter type for the parameter you want to reset to default is Static, the server requires a restart for the change to take effect. In this 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 revert a parameter value to its default.

az postgres flexible-server parameter set \
  --resource-group <resource_group> \
  --server-name <server> \
  --source user-override \
  --name <parameter> \
  --value $(az postgres flexible-server parameter show \
              --resource-group <resource_group> \
              --server-name <server> \
              --name <parameter> \
              --output tsv) 

To conditionally restart the server if the parameter change requires a restart, use the following script:

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