Revert all parameters to their default values

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. 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: 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 the value of all read-write parameters to their default values.

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

To conditionally restart the server if any parameter changes require 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