Revert all parameters to their defaults

This article provides step-by-step instructions to revert all parameters to their defaults of an Azure Database for PostgreSQL flexible server.

Steps to revert all parameters to their defaults

Portal

Using the Azure portal:

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

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

   

3. Select the Modified tab.

   

4. Select Reset all to default.

   

5. If you want to proceed with resetting all modified parameters to their default values, confirm the operation in the Reset all to default values dialog.

   

6. If, for any of the parameters whose current value doesn't match their default, the column Parameter type is equal to Static, the server requires a restart for the change 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 parameters don't take effect.
   • Cancel: To not implement any changes yet.

   

CLI

You can revert the value of all read-write parameters to their defaults via the az postgres flexible-server parameter set command.

parameters_to_reset=$(az postgres flexible-server parameter list \
                        --resource-group <resource_group> \
                        --server-name <server> \
                        --query "[?value!=defaultValue && isReadOnly==\`false\`].name" \
                        -output tsv)
for parameter_to_reset in $parameters_to_reset; do
  az postgres flexible-server parameter set \
    --resource-group <resource_group> \
    --server-name <server> \
    --name $parameter_to_reset \
    --value $(az postgres flexible-server parameter show \
                --resource-group <resource_group> \
                --server-name <server> \
                --name $parameter_to_reset \
                --output tsv)
done

And you can use the following script to conditionally restart the server, if any of the parameters changed require a restart for their 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 parameters.
• List parameters with modified values.
• List read-write static parameters.
• List read-write dynamic parameters.
• List read-only parameters.
• Set the value of one or more parameters.
• Revert one parameter to its default.