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

This article provides step-by-step instructions to list read-write static parameters of an Azure Database for PostgreSQL flexible server.

Steps to list read-write static parameters

Portal

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 Static tab. The page shows a list of read-write parameters that require a server restart for the new value to take effect if you change their value.

   

CLI

Use the az postgres flexible-server parameter list command to list all parameters that require a restart for changes to take effect.

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

Related contents

• List all parameters.
• List parameters with modified values.
• List read-write dynamic parameters.
• List read-only parameters.
• Set the value of one or more parameters.
• Revert one parameter to its default.
• Revert all parameters to their default.