List all parameters

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

Steps to list all parameters

Portal
CLI

Using the Azure portal:

Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, select Parameters.
The page shows a list of parameters, their configured values, optional units, whether they're read-only, dynamic, or static, and their descriptions.
Select or hover over the i (information) icon to see which values are allowed for each parameter. Depending on the data type of the parameter, which can be string, enumeration, integer, boolean, numeric, set, the allowed values vary. And it can be regular expression, list of values, range of integers, on/off, range of decimals, list of values, respectively.
The list of parameters supported by the server consists of several hundred items, which are rendered in pages of 20 items each. At the bottom of the page, there's a control to inform you of the position you're at.
There's also a paging control which you can use to navigate through the whole set of pages.
If needed, use the Search to filter items... text box to narrow down the list to those parameters containing the search term in their name or in their description.

The Source column can show any of the following values for each parameter:

Parameter type	Description
System-Default	Value of the parameter is never overridden, neither by the user nor by the platform.
User-Override	Value of the parameter is overridden, either by the user or by the system.

The Parameter type column can show any of the following values for each parameter:

Parameter type	Description
Static	Requires a server restart to make the change effective.
Dynamic	Can be altered without the need to restart the server instance. However, changes apply only to new connections established after the modification.
Read-only	Isn't user configurable, because of its critical role in maintaining reliability, security, or other operational aspects of the service.

Use the az postgres flexible-server parameter list command to list all parameters in a server.

az postgres flexible-server parameter list \
  --resource-group <resource_group> \
  --server-name <server>

Each parameter has the following attributes:

Attribute name	Description	Possible values
allowedValues	Describes the values that are allowed for the parameter.	Depending on the value of dataType, can be a regular expression (string), list of values (enumeration), range of integers (integer), on/off (boolean), range of decimals (numeric), list of values (set).
dataType	Type of data used for the parameter.	Can be any of `boolean`, `enumeration`, `integer`, `numeric`, `set`, `string`.
defaultValue	Value assigned to the parameter when a new server is deployed.	Varies, depending on the data type and allowed values of the parameter.
description	Brief explanation of what the parameter controls.	Textual description which is different for each parameter.
documentationLink	URL address of the page pointing to the documentation of the parameter.	Some form of URL.
id	Resource identifier that uniquely refers to the parameter in this particular instance of flexible server.	A string that follows the pattern `/subscriptions/<subscription_identifier>/resourceGroups/<resource_group_name>/providers/Microsoft.DBforPostgreSQL/flexibleServers/<server_name>/configurations/<parameter_name>`.
isConfigPendingRestart	Indicates whether a server restart is required for the value currently set in the value attribute to take effect.	`true`: for parameters whose value was changed and, because they aren't dynamic (that is, they're static), require a server restart for the change to take effect. `false`: for parameters whose value currently set in the value attribute is in effect, and aren't waiting for a server restart to take effect.
isDynamicConfig	Indicates whether a change in the value assigned to the parameter doesn't require or requires a server restart, for the change to take effect.	`true`: for parameters that, when their value changes, the change takes effect immediately. `false`: for parameters that, when their value changes, require a server restart for the change to take effect.
isReadOnly	Indicates if the user can or can't override the default value assigned to the parameter.	`true`: for parameters that are designated as read-only and the user can't change. `false`: for parameters that are designated as read-write and the user can set to a different value than their default.
name	Name of the parameter.	Any valid name for a parameter.
resourceGroup	Name of the resource group in which the server is deployed.	Any valid name for a resource group in Azure.
source	Source from which the value currently set for the parameter originates.	`system-default` or `user-override`, depending on whether value is set to the system default or was overriden by the user or the platform.
unit	Optional text describing the units in which the parameter is expressed.	When set to something, it can be any of `8KB`, `bytes`, `days`, `KB`, `megabytes`, `microseconds`, `milliseconds`, `minutes`, `percentage`, `seconds`.
value	Value currently assigned to the parameter.	Varies, depending on the data type and allowed values of the parameter.

Feedback

Was this page helpful?

Last updated on 2026-06-29

List all parameters

Steps to list all parameters

Related contents

Feedback

Additional resources