List read-write dynamic parameters in Azure Database for PostgreSQL flexible server

Use 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 Dynamic tab. The page shows a list of read-write parameters for which, if you change their value, the new value takes effect immediately without requiring a server restart.

   

Use the az postgres flexible-server parameter list command to list all parameters that don't require a restart after you change their values.

az postgres flexible-server parameter list \
  --resource-group <resource_group> \
  --server-name <server> \
  --query "[?isDynamicConfig==\`true\` && isReadOnly==\`false\`] | [].name"