List server parameters with modified defaults

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

Steps to list server parameters with modified defaults

Portal

Using the Azure portal:

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

2. In the resource menu, under Settings, select Server parameters.

   

3. Select the Modified tab. The page shows a list of parameters whose currently set value deviates from the default.

   

CLI

You can list all server parameters whose values are modified from defaults, via the az postgres flexible-server parameter list command.

az postgres flexible-server parameter list \
  --resource-group <resource_group> \
  --server-name <server> \
  --query "[?value!=defaultValue && isReadOnly==\`false\` && name!='temp_tablespaces' && name!='vacuum_cost_page_miss'] | [].name"

Note

Previous CLI command doesn't consider modified server parameters the ones which are designated as read-only, temp_tablespaces, and vacuum_cost_page_miss, following the exact same criteria as the Server parameters page in the Azure portal.

Related contents

• List all server parameters.
• 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.
• Revert all server parameters to their default.