Revert all server parameters to their defaults

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

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

Steps to revert all server 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 Server parameters.

   

3. Select the Modified tab.

   

4. Select Reset all to default.

   

5. If you want to proceed with resetting all modified server 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 server parameters don't take effect.
   • Cancel: To not implement any changes yet.

   

CLI

You can revert the value of all read-write server 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" -o 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 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.
• Set the value of one or more server parameters.
• Revert one server parameter to its default.