APPLIES TO:
Azure Database for PostgreSQL - Flexible Server
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
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.