az postgres flexible-server

Команды

Имя	Описание	Тип	Состояние
az postgres flexible-server ad-admin	Manage server Microsoft Entra administrators.	Ядро	Устарело
az postgres flexible-server ad-admin create	Create a Microsoft Entra administrator.	Ядро	Устарело
az postgres flexible-server ad-admin delete	Delete a Microsoft Entra administrator.	Ядро	Устарело
az postgres flexible-server ad-admin list	List all Microsoft Entra administrators.	Ядро	Устарело
az postgres flexible-server ad-admin show	Get a Microsoft Entra administrator.	Ядро	Устарело
az postgres flexible-server ad-admin wait	Wait for a Microsoft Entra administrator to satisfy certain conditions.	Ядро	Устарело
az postgres flexible-server advanced-threat-protection-setting	Manage advanced threat protection setting for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server advanced-threat-protection-setting show	Get advanced threat protection settings for a PostgreSL flexible server.	Ядро	GA
az postgres flexible-server advanced-threat-protection-setting update	Updates advanced threat protection setting state for a flexible server.	Ядро	GA
az postgres flexible-server backup	Manage flexible server backups.	Ядро	GA
az postgres flexible-server backup create	Create a new backup for a flexible server.	Ядро	GA
az postgres flexible-server backup delete	Delete a specific backup.	Ядро	GA
az postgres flexible-server backup list	List all the backups for a given server.	Ядро	GA
az postgres flexible-server backup show	Show the details of a specific backup for a given server.	Ядро	GA
az postgres flexible-server connect	Connect to a flexible server.	Расширение	GA
az postgres flexible-server create	Create a PostgreSQL flexible server.	Ядро	Устарело
az postgres flexible-server db	Manage PostgreSQL databases on a flexible server.	Ядро	GA
az postgres flexible-server db create	Create a PostgreSQL database on a flexible server.	Ядро	GA
az postgres flexible-server db delete	Delete a database on a flexible server.	Ядро	GA
az postgres flexible-server db list	List the databases for a flexible server.	Ядро	GA
az postgres flexible-server db show	Show the details of a database.	Ядро	GA
az postgres flexible-server delete	Delete a flexible server.	Ядро	GA
az postgres flexible-server deploy	Enable and run GitHub Actions workflow for PostgreSQL server.	Ядро	GA
az postgres flexible-server deploy run	Run an existing workflow in your github repository.	Ядро	GA
az postgres flexible-server deploy setup	Create GitHub Actions workflow file for PostgreSQL server.	Ядро	GA
az postgres flexible-server execute	Connect to a flexible server.	Расширение	GA
az postgres flexible-server fabric-mirroring	Bring your PostgreSQL data into Microsoft Fabric. Mirroring allows you to create a replica of your data in OneLake which can be used for all your analytical needs.	Ядро	GA
az postgres flexible-server fabric-mirroring start	Enable bringing your PostgreSQL data into Microsoft Fabric.	Ядро	GA
az postgres flexible-server fabric-mirroring stop	Stop bringing your PostgreSQL data into Microsoft Fabric.	Ядро	GA
az postgres flexible-server fabric-mirroring update-databases	Update allowed mirrored databases.	Ядро	GA
az postgres flexible-server firewall-rule	Manage firewall rules for a server.	Ядро	GA
az postgres flexible-server firewall-rule create	Create a new firewall rule for a flexible server.	Ядро	GA
az postgres flexible-server firewall-rule delete	Delete a firewall rule.	Ядро	GA
az postgres flexible-server firewall-rule list	List all firewall rules for a flexible server.	Ядро	GA
az postgres flexible-server firewall-rule show	Get the details of a firewall rule.	Ядро	GA
az postgres flexible-server firewall-rule update	Update a firewall rule.	Ядро	GA
az postgres flexible-server geo-restore	Geo-restore a flexible server from backup.	Ядро	GA
az postgres flexible-server identity	Manage server user assigned identities.	Ядро	GA
az postgres flexible-server identity assign	Add user assigned managed identities to the server.	Ядро	GA
az postgres flexible-server identity list	List all user assigned managed identities from the server.	Ядро	GA
az postgres flexible-server identity remove	Remove user assigned managed identites from the server.	Ядро	GA
az postgres flexible-server identity show	Get an user assigned managed identity from the server.	Ядро	GA
az postgres flexible-server identity update	Update to enable or disable system assigned managed identity on the server.	Ядро	GA
az postgres flexible-server index-tuning	Index tuning analyzes read queries captured in Query Store and recommends index changes to optimize these queries.	Ядро	GA
az postgres flexible-server index-tuning list-recommendations	Get available tuning index recommendations associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server index-tuning list-settings	Get tuning settings associated for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server index-tuning set-settings	Update a tuning setting for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server index-tuning show	Show state of index tuning for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server index-tuning show-settings	Get a tuning setting for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server index-tuning update	Update index tuning to be enabled/disabled for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server list	List available flexible servers.	Ядро	GA
az postgres flexible-server list-skus	Lists available sku's in the given region.	Ядро	GA
az postgres flexible-server long-term-retention	Manage flexible server long-term-retention backups.	Ядро	GA
az postgres flexible-server long-term-retention list	List all the long-term-retention backups for a given server.	Ядро	GA
az postgres flexible-server long-term-retention pre-check	Performs all the checks that are needed for the subsequent long-term-retention backup operation to succeed.	Ядро	GA
az postgres flexible-server long-term-retention show	Show the details of a specific long-term-retention backup for a given server.	Ядро	GA
az postgres flexible-server long-term-retention start	Start long-term-retention backup for a flexible server. SAS URL parameter refers to the container SAS URL, inside the storage account, where the backups will be uploaded.	Ядро	GA
az postgres flexible-server microsoft-entra-admin	Manage server Microsoft Entra administrators.	Ядро	GA
az postgres flexible-server microsoft-entra-admin create	Create a Microsoft Entra administrator.	Ядро	GA
az postgres flexible-server microsoft-entra-admin delete	Delete a Microsoft Entra administrator.	Ядро	GA
az postgres flexible-server microsoft-entra-admin list	List all Microsoft Entra administrators.	Ядро	GA
az postgres flexible-server microsoft-entra-admin show	Get a Microsoft Entra administrator.	Ядро	GA
az postgres flexible-server microsoft-entra-admin wait	Wait for a Microsoft Entra administrator to satisfy certain conditions.	Ядро	GA
az postgres flexible-server migration	Manage migration workflows for PostgreSQL Flexible Servers.	Ядро	GA
az postgres flexible-server migration check-name-availability	Checks if the provided migration-name can be used.	Ядро	GA
az postgres flexible-server migration create	Create a new migration workflow for a flexible server.	Ядро	GA
az postgres flexible-server migration list	List the migrations of a flexible server.	Ядро	GA
az postgres flexible-server migration show	Get the details of a specific migration.	Ядро	GA
az postgres flexible-server migration update	Update a specific migration.	Ядро	GA
az postgres flexible-server parameter	Commands for managing server parameter values for flexible server.	Ядро	GA
az postgres flexible-server parameter list	List the parameter values for a flexible server.	Ядро	GA
az postgres flexible-server parameter set	Update the parameter of a flexible server.	Ядро	GA
az postgres flexible-server parameter show	Get the parameter for a flexible server.".	Ядро	GA
az postgres flexible-server private-endpoint-connection	Manage PostgreSQL flexible server private endpoint connections.	Ядро	GA
az postgres flexible-server private-endpoint-connection approve	Approve the specified private endpoint connection associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-endpoint-connection delete	Delete the specified private endpoint connection associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-endpoint-connection list	List all private endpoint connections associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-endpoint-connection reject	Reject the specified private endpoint connection associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-endpoint-connection show	Show details of a private endpoint connection associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-link-resource	Get Private link resource for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-link-resource list	List private link resources associated with a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server private-link-resource show	Get private link resource for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server replica	Manage read replicas.	Ядро	GA
az postgres flexible-server replica create	Create a read replica for a server.	Ядро	GA
az postgres flexible-server replica list	List all read replicas for a given server.	Ядро	GA
az postgres flexible-server replica promote	Stop replication of a read replica and promote it to an independent server or as a primary server.	Ядро	GA
az postgres flexible-server restart	Restart a flexible server.	Ядро	GA
az postgres flexible-server restore	Restore a flexible server from backup.	Ядро	GA
az postgres flexible-server revive-dropped	Revive a dropped flexible server from backup.	Ядро	GA
az postgres flexible-server server-logs	Manage server logs (log files) for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server server-logs download	Download log files for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server server-logs list	List log files for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server show	Get the details of a flexible server.	Ядро	GA
az postgres flexible-server show-connection-string	Show the connection strings for a PostgreSQL flexible-server database.	Ядро	GA
az postgres flexible-server start	Start a flexible server.	Ядро	GA
az postgres flexible-server stop	Stop a flexible server.	Ядро	GA
az postgres flexible-server update	Update a flexible server.	Ядро	Устарело
az postgres flexible-server upgrade	Upgrade the major version of a flexible server.	Ядро	GA
az postgres flexible-server virtual-endpoint	Manage virtual endpoints for a PostgreSQL flexible server.	Ядро	GA
az postgres flexible-server virtual-endpoint create	Create a new virtual endpoint for a flexible server.	Ядро	GA
az postgres flexible-server virtual-endpoint delete	Delete a virtual endpoint.	Ядро	GA
az postgres flexible-server virtual-endpoint list	List all virtual endpoints for a flexible server.	Ядро	GA
az postgres flexible-server virtual-endpoint show	Get the details of a virtual endpoint.	Ядро	GA
az postgres flexible-server virtual-endpoint update	Update a virtual endpoint.	Ядро	GA
az postgres flexible-server wait	Wait for the flexible server to satisfy certain conditions.	Ядро	GA

az postgres flexible-server connect --admin-user
                                    --name
                                    [--admin-password]
                                    [--database-name]
                                    [--interactive]
                                    [--querytext]

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server create [--active-directory-auth {Disabled, Enabled}]
                                   [--address-prefixes]
                                   [--admin-display-name]
                                   [--admin-object-id]
                                   [--admin-password]
                                   [--admin-type {Group, ServicePrincipal, Unknown, User}]
                                   [--admin-user]
                                   [--backup-identity]
                                   [--backup-key]
                                   [--backup-retention]
                                   [--cluster-option {ElasticCluster, Server}]
                                   [--create-default-database {Disabled, Enabled}]
                                   [--database-name]
                                   [--geo-redundant-backup {Disabled, Enabled}]
                                   [--high-availability {Disabled, SameZone, ZoneRedundant}]
                                   [--identity]
                                   [--iops]
                                   [--key]
                                   [--location]
                                   [--microsoft-entra-auth {Disabled, Enabled}]
                                   [--name]
                                   [--node-count]
                                   [--password-auth {Disabled, Enabled}]
                                   [--performance-tier]
                                   [--private-dns-zone]
                                   [--public-access]
                                   [--resource-group]
                                   [--sku-name]
                                   [--standby-zone]
                                   [--storage-auto-grow {Disabled, Enabled}]
                                   [--storage-size]
                                   [--storage-type {PremiumV2_LRS, Premium_LRS}]
                                   [--subnet]
                                   [--subnet-prefixes]
                                   [--tags]
                                   [--throughput]
                                   [--tier]
                                   [--version]
                                   [--vnet]
                                   [--yes]
                                   [--zone]

Примеры

Create a PostgreSQL flexible server with custom parameters

az postgres flexible-server create --location northeurope --resource-group testGroup \
  --name testserver --admin-user username --admin-password password \
  --sku-name Standard_D2s_v3 --tier GeneralPurpose --public-access 153.24.26.117 --storage-size 128 \
  --tags "key=value" --version 17 --high-availability ZoneRedundant --zone 1 \
  --standby-zone 3

Create a PostgreSQL flexible server using Premium SSD v2 Disks.

# set storage type to "PremiumV2_LRS" and provide values for Storage size (in GiB), IOPS (operations/sec), and Throughput (MB/sec).
az postgres flexible-server create --location northeurope --resource-group testGroup \
    --name testserver --admin-user username --admin-password password \
    --sku-name Standard_B1ms --tier Burstable --storage-type PremiumV2_LRS --storage-size 128 --iops 3000 --throughput 125

Create a PostgreSQL flexible server with default parameters and public access enabled by default. Resource group, server name, username, password, and default database will be created by CLI

az postgres flexible-server create

Create a PostgreSQL flexible server with public access and add the range of IP address to have access to this server. The --public-access parameter can be 'Disabled', 'Enabled', 'All', 'None', <startIpAddress>, or <startIpAddress>-<endIpAddress>

az postgres flexible-server create --resource-group testGroup --name testserver --public-access 125.23.54.31-125.23.54.35

Create a PostgreSQL flexible server with private access. If provided virtual network and subnet do not exists, virtual network and subnet with the specified address prefixes will be created.

az postgres flexible-server create --resource-group testGroup --name testserver --vnet myVnet --subnet mySubnet --address-prefixes 10.0.0.0/16 --subnet-prefixes 10.0.0.0/24

Create a PostgreSQL flexible server using a new subnet resource ID and new private DNS zone resource ID. The subnet and DNS zone can be created in different subscription or resource group.

az postgres flexible-server create \
  --resource-group testGroup --name testserver \
  --subnet /subscriptions/{SubID}/resourceGroups/{ResourceGroup}/providers/Microsoft.Network/virtualNetworks/{VNetName}/subnets/{SubnetName} \
  --private-dns-zone /subscriptions/{SubID}/resourceGroups/{resourceGroup}/providers/Microsoft.Network/privateDnsZones/testPostgreSQLFlexibleDnsZone.private.postgres.database.azure.com \
  --address-prefixes 172.0.0.0/16 --subnet-prefixes 172.0.0.0/24

Create a PostgreSQL flexible server using existing network resources in the same resource group. The provided subnet should not have any other resource deployed in it and this subnet will be delegated to Microsoft.DBforPostgreSQL/flexibleServers, if not already delegated. The private DNS zone will be linked to the virtual network if not already linked.

# create vnet
az network vnet create --resource-group testGroup --name testVnet --location testLocation --address-prefixes 172.0.0.0/16

# create subnet
az network vnet subnet create --resource-group testGroup --vnet-name testVnet --address-prefixes 172.0.0.0/24 --name testSubnet

# create private dns zone
az network private-dns zone create -g testGroup -n testDNS.private.postgres.database.azure.com

az postgres flexible-server create --resource-group testGroup \
  --name testserver --location testLocation \
  --subnet /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/virtualNetworks/tesetVnet/subnets/testSubnet \
  --private-dns-zone /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/privateDnsZones/testDNS.postgres.database.azure.com\


az postgres flexible-server create --resource-group testGroup --name testserver \
  --vnet testVnet --subnet testSubnet --location testLocation \
  --private-dns-zone /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/privateDnsZones/testDNS.postgres.database.azure.com

Create a PostgreSQL flexible server using existing network resources in the different resource group / subscription.

az postgres flexible-server create --resource-group testGroup \
   --name testserver --location testLocation \
  --subnet /subscriptions/{SubId2}/resourceGroups/{testGroup2}/providers/Microsoft.Network/virtualNetworks/tesetVnet/subnets/testSubnet \
  --private-dns-zone /subscriptions/{SubId2}/resourceGroups/{testGroup2}/providers/Microsoft.Network/privateDnsZones/testDNS.postgres.database.azure.com

Create a PostgreSQL flexible server with data encryption.

# create keyvault
az keyvault create -g testGroup -n testVault --location testLocation \
  --enable-purge-protection true


# create key in keyvault and save its key identifier
keyIdentifier=$(az keyvault key create --name testKey -p software \
  --vault-name testVault --query key.kid -o tsv)


# create identity and save its principalId
identityPrincipalId=$(az identity create -g testGroup --name testIdentity \
  --location testLocation --query principalId -o tsv)


# add testIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testVault
az keyvault set-policy -g testGroup -n testVault --object-id $identityPrincipalId \
  --key-permissions wrapKey unwrapKey get list


# create flexible server with data encryption enabled
az postgres flexible-server create -g testGroup -n testServer --location testLocation \
  --key $keyIdentifier --identity testIdentity

Create a PostgreSQL flexible server with Microsoft Entra auth as well as password auth.

# create flexible server with aad auth and password auth enabled
az postgres flexible-server create -g testGroup -n testServer --location testLocation \
  --microsoft-entra-auth Enabled

Create a PostgreSQL flexible server with Microsoft Entra auth only and primary administrator specified.

# create flexible server with aad only auth and password auth disabled with primary administrator specified
az postgres flexible-server create -g testGroup -n testServer --location testLocation \
  --microsoft-entra-auth Enabled --password-auth Disabled \
  --admin-object-id 00000000-0000-0000-0000-000000000000 --admin-display-name [email protected] --admin-type User

Create a PostgreSQL flexible server with public access, geo-redundant backup enabled and add the range of IP address to have access to this server. The --public-access parameter can be 'All', 'None', <startIpAddress>, or <startIpAddress>-<endIpAddress>

az postgres flexible-server create --resource-group testGroup --name testserver --geo-redundant-backup Enabled --public-access 125.23.54.31-125.23.54.35

Create a PostgreSQL flexible server with data encryption for geo-rundundant backup enabled server.

# create keyvault
az keyvault create -g testGroup -n testVault --location testLocation \
  --enable-purge-protection true


# create key in keyvault and save its key identifier
keyIdentifier=$(az keyvault key create --name testKey -p software \
  --vault-name testVault --query key.kid -o tsv)


# create identity and save its principalId
identityPrincipalId=$(az identity create -g testGroup --name testIdentity \
  --location testLocation --query principalId -o tsv)


# add testIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testVault
az keyvault set-policy -g testGroup -n testVault --object-id $identityPrincipalId \
  --key-permissions wrapKey unwrapKey get list

# create keyvault in geo-paired region
az keyvault create -g testGroup -n geoVault --location geoPairedLocation \
  --enable-purge-protection true


# create key in keyvault and save its key identifier
geoKeyIdentifier=$(az keyvault key create --name geoKey -p software \
  --vault-name geoVault --query key.kid -o tsv)


# create identity in geo-raired location and save its principalId
geoIdentityPrincipalId=$(az identity create -g testGroup --name geoIdentity \
  --location geoPairedLocation --query principalId -o tsv)


# add testIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testVault
az keyvault set-policy -g testGroup -n geoVault --object-id $geoIdentityPrincipalId \
  --key-permissions wrapKey unwrapKey get list


# create flexible server with data encryption enabled for geo-backup Enabled server
az postgres flexible-server create -g testGroup -n testServer --location testLocation --geo-redundant-backup Enabled \
  --key $keyIdentifier --identity testIdentity --backup-key $geoKeyIdentifier --backup-identity geoIdentity

Create flexible server with custom storage performance tier. Accepted values "P4", "P6", "P10", "P15", "P20", "P30", \ "P40", "P50", "P60", "P70", "P80". Actual allowed values depend on the --storage-size selection for flexible server creation. \ Default value for storage performance tier depends on the --storage-size selected for flexible server creation.

az postgres flexible-server create -g testGroup -n testServer --location testLocation --performance-tier P15

Create flexible server with storage auto-grow as Enabled. Accepted values Enabled / Disabled. Default value for storage auto-grow is "Disabled".

az postgres flexible-server create -g testGroup -n testServer --location testLocation --storage-auto-grow Enabled

Create elastic cluster with node count of 5. Default node count is 2 when --cluster-option is "ElasticCluster".

az postgres flexible-server create -g testGroup -n testCluster --location testLocation --cluster-option ElasticCluster --node-count 5

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server delete [--ids]
                                   [--name]
                                   [--resource-group]
                                   [--subscription]
                                   [--yes]

Примеры

Delete a flexible server.

az postgres flexible-server delete --resource-group testGroup --name testserver

Delete a flexible server without prompt or confirmation.

az postgres flexible-server delete --resource-group testGroup --name testserver --yes

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server execute --admin-password
                                    --admin-user
                                    --name
                                    [--database-name]
                                    [--file-path]
                                    [--querytext]

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server geo-restore --location
                                        --source-server
                                        [--address-prefixes]
                                        [--backup-identity]
                                        [--backup-key]
                                        [--geo-redundant-backup {Disabled, Enabled}]
                                        [--identity]
                                        [--ids]
                                        [--key]
                                        [--name]
                                        [--no-wait]
                                        [--private-dns-zone]
                                        [--resource-group]
                                        [--restore-time]
                                        [--subnet]
                                        [--subnet-prefixes]
                                        [--subscription]
                                        [--vnet]
                                        [--yes]
                                        [--zone]

Примеры

Geo-restore public access server 'testserver' to a new server 'testserverNew' in location 'newLocation' with public access.

az postgres flexible-server geo-restore --resource-group testGroup --name testserverNew --source-server testserver --location newLocation

Geo-restore private access server 'testserver' as a new server 'testserverNew' with new subnet. New vnet, subnet, and private dns zone for the restored server will be provisioned. Please refer to 'flexible-server create' command for more private access scenarios.

az postgres flexible-server geo-restore --resource-group testGroup --name testserverNew \
  --source-server testserver --vnet newVnet --subnet newSubnet \
  --address-prefixes 172.0.0.0/16 --subnet-prefixes 172.0.0.0/24 \
  --private-dns-zone testDNS.postgres.database.azure.com --location newLocation

Geo-restore 'testserver' to current point-in-time as a new server 'testserverNew' in a different subscription / resource group. \ Here --resource-group is for the target server's resource group, and --source-server must be passed as resource ID. \ This resource ID can be in a subscription different than the subscription used for az account set.

az postgres flexible-server geo-restore --resource-group testGroup --name testserverNew --location newLocation \
  --source-server /subscriptions/{sourceSubscriptionId}/resourceGroups/{sourceResourceGroup}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{sourceServerName}

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server list [--resource-group]
                                 [--show-cluster]

Примеры

List all PostgreSQL flexible servers in a subscription.

az postgres flexible-server list

List all PostgreSQL flexible servers in a resource group.

az postgres flexible-server list --resource-group testGroup

List all PostgreSQL flexible servers in a resource group in table format.

az postgres flexible-server list --resource-group testGroup --output table

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server list-skus --location

Обязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server restart [--failover]
                                    [--ids]
                                    [--name]
                                    [--resource-group]
                                    [--subscription]

Примеры

Restart a flexible server.

az postgres flexible-server restart --resource-group testGroup --name testserver

Restart a server with planned failover

az postgres flexible-server restart --resource-group testGroup --name testserver --failover Planned

Restart a server with forced failover

az postgres flexible-server restart --resource-group testGroup --name testserver --failover Forced

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server restore --source-server
                                    [--address-prefixes]
                                    [--backup-identity]
                                    [--backup-key]
                                    [--geo-redundant-backup {Disabled, Enabled}]
                                    [--identity]
                                    [--ids]
                                    [--key]
                                    [--name]
                                    [--no-wait]
                                    [--private-dns-zone]
                                    [--resource-group]
                                    [--restore-time]
                                    [--storage-type {PremiumV2_LRS}]
                                    [--subnet]
                                    [--subnet-prefixes]
                                    [--subscription]
                                    [--vnet]
                                    [--yes]
                                    [--zone]

Примеры

Restore 'testserver' to a specific point-in-time as a new server 'testserverNew'.

az postgres flexible-server restore --resource-group testGroup --name testserverNew --source-server testserver --restore-time "2017-06-15T13:10:00Z"

Restore 'testserver' to current point-in-time as a new server 'testserverNew'.

az postgres flexible-server restore --resource-group testGroup --name testserverNew --source-server testserver

Restore 'testserver' to current point-in-time as a new server 'testserverNew' in a different resource group. \ Here --resource-group is for the target server's resource group, and --source-server must be passed as resource ID.

az postgres flexible-server restore --resource-group testGroup --name testserverNew \
  --source-server /subscriptions/{testSubscription}/resourceGroups/{sourceResourceGroup}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{sourceServerName}

Restore 'testserver' to current point-in-time as a new server 'testserverNew' in a different subscription. \ Here --resource-group is for the target server's resource group, and --source-server must be passed as resource ID. \ This resource ID can be in a subscription different than the subscription used for az account set.

az postgres flexible-server restore --resource-group testGroup --name testserverNew \
  --source-server /subscriptions/{sourceSubscriptionId}/resourceGroups/{sourceResourceGroup}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{sourceServerName}

Restore 'testserver' to current point-in-time as a new server 'testserverNew' using Premium SSD v2 Disks by setting storage type to "PremiumV2_LRS"

az postgres flexible-server restore --resource-group testGroup --name testserverNew --source-server testserver --storage-type PremiumV2_LRS

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server revive-dropped --location
                                           --source-server
                                           [--address-prefixes]
                                           [--backup-identity]
                                           [--backup-key]
                                           [--geo-redundant-backup {Disabled, Enabled}]
                                           [--identity]
                                           [--ids]
                                           [--key]
                                           [--name]
                                           [--no-wait]
                                           [--private-dns-zone]
                                           [--resource-group]
                                           [--subnet]
                                           [--subnet-prefixes]
                                           [--subscription]
                                           [--vnet]
                                           [--yes]
                                           [--zone]

Примеры

Revive dropped public access server 'testserver' to a new server 'testserverNew' in location 'newLocation' with public access.

az postgres flexible-server revive-dropped --resource-group testGroup --name testserverNew --source-server /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.DBforPostgreSQL/flexibleServers/testserver --location newLocation

Revive dropped public access server 'testserver' with data encryption enabled as a new server 'testserverNew' with data encryption.

az postgres flexible-server revive-dropped -l testLocation --resource-group testGroup --name testserverNew \
  --source-server testserver --key newKeyIdentifier --identity newIdentity

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server show [--ids]
                                 [--name]
                                 [--resource-group]
                                 [--subscription]

Примеры

Get the details of a flexible server

az postgres flexible-server show --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server show-connection-string [--admin-password]
                                                   [--admin-user]
                                                   [--database-name]
                                                   [--ids]
                                                   [--pg-bouncer]
                                                   [--server-name]
                                                   [--subscription]

Примеры

Show connection strings for cmd and programming languages.

az postgres flexible-server show-connection-string -s testserver -u username -p password -d databasename

Show connection strings for cmd and programming languages with PgBouncer enabled.

az postgres flexible-server show-connection-string -s testserver -u username -p password -d databasename --pg-bouncer

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server start [--ids]
                                  [--name]
                                  [--no-wait]
                                  [--resource-group]
                                  [--subscription]

Примеры

Start a flexible server.

az postgres flexible-server start --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server stop [--ids]
                                 [--name]
                                 [--no-wait]
                                 [--resource-group]
                                 [--subscription]

Примеры

Stop a flexible server.

az postgres flexible-server stop --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server update [--active-directory-auth {Disabled, Enabled}]
                                   [--add]
                                   [--admin-password]
                                   [--backup-identity]
                                   [--backup-key]
                                   [--backup-retention]
                                   [--force-string]
                                   [--high-availability {Disabled, SameZone, ZoneRedundant}]
                                   [--identity]
                                   [--ids]
                                   [--iops]
                                   [--key]
                                   [--maintenance-window]
                                   [--microsoft-entra-auth {Disabled, Enabled}]
                                   [--name]
                                   [--node-count]
                                   [--password-auth {Disabled, Enabled}]
                                   [--performance-tier]
                                   [--private-dns-zone]
                                   [--public-access {Disabled, Enabled}]
                                   [--remove]
                                   [--resource-group]
                                   [--set]
                                   [--sku-name]
                                   [--standby-zone]
                                   [--storage-auto-grow {Disabled, Enabled}]
                                   [--storage-size]
                                   [--subscription]
                                   [--tags]
                                   [--throughput]
                                   [--tier]
                                   [--yes]

Примеры

Update a flexible server's sku, using local context for server and resource group.

az postgres flexible-server update --sku-name Standard_D4s_v3

Update a server's tags.

az postgres flexible-server update --resource-group testGroup --name testserver --tags "k1=v1" "k2=v2"

Введите новый пароль

az postgres flexible-server update --resource-group testGroup --name testserver -p password123

Update a flexible server to enable Microsoft Entra auth for password auth enabled server

az postgres flexible-server update --resource-group testGroup --name testserver --microsoft-entra-auth Enabled

Change key/identity for data encryption. Data encryption cannot be enabled post server creation, this will only update the key/identity.

# get key identifier of the existing key
newKeyIdentifier=$(az keyvault key show --vault-name testVault --name testKey \
  --query key.kid -o tsv)


# update server with new key/identity
az postgres flexible-server update --resource-group testGroup --name testserver \
  --key $newKeyIdentifier --identity newIdentity

Update a flexible server to update private DNS zone for a VNET enabled server, using private DNS zone in the same resource group and subscription. Private DNS zone will be created Private DNS zone will be linked to the VNET if not already linked.

az postgres flexible-server update --resource-group testGroup --name testserver --private-dns-zone testDNS2.postgres.database.azure.com

Update a flexible server to update private DNS zone for a VNET enabled server, using private DNS zone in the different resource group and subscription. Private DNS zone will be linked to the VNET if not already linked.

az postgres flexible-server update --resource-group testGroup --name testserver --private-dns-zone /subscriptions/{SubId2}/resourceGroups/{testGroup2}/providers/Microsoft.Network/privateDnsZones/testDNS.postgres.database.azure.com

Update a flexible server's storage to enable / disable storage auto-grow.

az postgres flexible-server update --resource-group testGroup --name testserver --storage-auto-grow Enabled

Update a flexible server's storage to set custom storage performance tier.

az postgres flexible-server update --resource-group testGroup --name testserver --performance-tier P15

Update a flexible server's storage to set IOPS (operations/sec). Server must be using Premium SSD v2 Disks.

az postgres flexible-server update --resource-group testGroup --name testserver --iops 3000

Update a flexible server's storage to set Throughput (MB/sec). Server must be using Premium SSD v2 Disks.

az postgres flexible-server update --resource-group testGroup --name testserver --throughput 125

Update a flexible server's cluster size by scaling up node count. Must be an Elastic Cluster.

az postgres flexible-server update --resource-group testGroup --name testcluster --node-count 6

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server upgrade --version {12, 13, 14, 15, 16}
                                    [--ids]
                                    [--name]
                                    [--resource-group]
                                    [--subscription]
                                    [--yes]

Примеры

Upgrade server 'testsvr' to PostgreSQL major version 16.

az postgres flexible-server upgrade -g testgroup -n testsvr -v 16

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az postgres flexible-server wait [--created]
                                 [--custom]
                                 [--deleted]
                                 [--exists]
                                 [--ids]
                                 [--interval]
                                 [--name]
                                 [--resource-group]
                                 [--subscription]
                                 [--timeout]
                                 [--updated]

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.