az postgres
Note
This command group has commands that are defined in both Azure CLI and at least one extension. Install each extension to benefit from its extended capabilities. Learn more about extensions.
Manage Azure Database for PostgreSQL.
Commands
| Name | Description | Type | Status |
|---|---|---|---|
| az postgres flexible-server |
Manage Azure Database for PostgreSQL Flexible Servers. |
Core and Extension | GA |
| az postgres flexible-server advanced-threat-protection-setting |
Manage advanced threat protection setting for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server advanced-threat-protection-setting show |
Get advanced threat protection settings for a PostgreSL flexible server. |
Core | GA |
| az postgres flexible-server advanced-threat-protection-setting update |
Updates advanced threat protection setting state for a flexible server. |
Core | GA |
| az postgres flexible-server backup |
Manage flexible server backups. |
Core | GA |
| az postgres flexible-server backup create |
Create a new backup for a flexible server. |
Core | GA |
| az postgres flexible-server backup delete |
Delete a specific backup. |
Core | GA |
| az postgres flexible-server backup list |
List all the backups for a given server. |
Core | GA |
| az postgres flexible-server backup show |
Show the details of a specific backup for a given server. |
Core | GA |
| az postgres flexible-server connect |
Connect to a flexible server. |
Extension | GA |
| az postgres flexible-server create |
Create a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server db |
Manage PostgreSQL databases on a flexible server. |
Core | GA |
| az postgres flexible-server db create |
Create a PostgreSQL database on a flexible server. |
Core | GA |
| az postgres flexible-server db delete |
Delete a database on a flexible server. |
Core | GA |
| az postgres flexible-server db list |
List the databases for a flexible server. |
Core | GA |
| az postgres flexible-server db show |
Show the details of a database. |
Core | GA |
| az postgres flexible-server delete |
Delete a flexible server. |
Core | GA |
| az postgres flexible-server deploy |
Enable and run GitHub Actions workflow for PostgreSQL server. |
Core | GA |
| az postgres flexible-server deploy run |
Run an existing workflow in your github repository. |
Core | GA |
| az postgres flexible-server deploy setup |
Create GitHub Actions workflow file for PostgreSQL server. |
Core | GA |
| az postgres flexible-server execute |
Connect to a flexible server. |
Extension | 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. |
Core | GA |
| az postgres flexible-server fabric-mirroring start |
Enable bringing your PostgreSQL data into Microsoft Fabric. |
Core | GA |
| az postgres flexible-server fabric-mirroring stop |
Stop bringing your PostgreSQL data into Microsoft Fabric. |
Core | GA |
| az postgres flexible-server fabric-mirroring update-databases |
Update allowed mirrored databases. |
Core | GA |
| az postgres flexible-server firewall-rule |
Manage firewall rules for a server. |
Core | GA |
| az postgres flexible-server firewall-rule create |
Create a new firewall rule for a flexible server. |
Core | GA |
| az postgres flexible-server firewall-rule delete |
Delete a firewall rule. |
Core | GA |
| az postgres flexible-server firewall-rule list |
List all firewall rules for a flexible server. |
Core | GA |
| az postgres flexible-server firewall-rule show |
Get the details of a firewall rule. |
Core | GA |
| az postgres flexible-server firewall-rule update |
Update a firewall rule. |
Core | GA |
| az postgres flexible-server geo-restore |
Geo-restore a flexible server from backup. |
Core | GA |
| az postgres flexible-server identity |
Manage server user assigned identities. |
Core | GA |
| az postgres flexible-server identity assign |
Add user assigned managed identities to the server. |
Core | GA |
| az postgres flexible-server identity list |
List all user assigned managed identities from the server. |
Core | GA |
| az postgres flexible-server identity remove |
Remove user assigned managed identites from the server. |
Core | GA |
| az postgres flexible-server identity show |
Get an user assigned managed identity from the server. |
Core | GA |
| az postgres flexible-server identity update |
Update to enable or disable system assigned managed identity on the server. |
Core | GA |
| az postgres flexible-server index-tuning |
Index tuning analyzes read queries captured in Query Store and recommends index changes to optimize these queries. |
Core | GA |
| az postgres flexible-server index-tuning list-recommendations |
Get available tuning index recommendations associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server index-tuning list-settings |
Get tuning settings associated for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server index-tuning set-settings |
Update a tuning setting for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server index-tuning show |
Show state of index tuning for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server index-tuning show-settings |
Get a tuning setting for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server index-tuning update |
Update index tuning to be enabled/disabled for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server list |
List available flexible servers. |
Core | GA |
| az postgres flexible-server list-skus |
Lists available sku's in the given region. |
Core | GA |
| az postgres flexible-server long-term-retention |
Manage flexible server long-term-retention backups. |
Core | GA |
| az postgres flexible-server long-term-retention list |
List all the long-term-retention backups for a given server. |
Core | 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. |
Core | GA |
| az postgres flexible-server long-term-retention show |
Show the details of a specific long-term-retention backup for a given server. |
Core | 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. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin |
Manage server Microsoft Entra administrators. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin create |
Create a Microsoft Entra administrator. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin delete |
Delete a Microsoft Entra administrator. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin list |
List all Microsoft Entra administrators. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin show |
Get a Microsoft Entra administrator. |
Core | GA |
| az postgres flexible-server microsoft-entra-admin wait |
Wait for a Microsoft Entra administrator to satisfy certain conditions. |
Core | GA |
| az postgres flexible-server migration |
Manage migration workflows for PostgreSQL Flexible Servers. |
Core | GA |
| az postgres flexible-server migration check-name-availability |
Checks if the provided migration-name can be used. |
Core | GA |
| az postgres flexible-server migration create |
Create a new migration workflow for a flexible server. |
Core | GA |
| az postgres flexible-server migration list |
List the migrations of a flexible server. |
Core | GA |
| az postgres flexible-server migration show |
Get the details of a specific migration. |
Core | GA |
| az postgres flexible-server migration update |
Update a specific migration. |
Core | GA |
| az postgres flexible-server parameter |
Commands for managing server parameter values for flexible server. |
Core | GA |
| az postgres flexible-server parameter list |
List the parameter values for a flexible server. |
Core | GA |
| az postgres flexible-server parameter set |
Update the parameter of a flexible server. |
Core | GA |
| az postgres flexible-server parameter show |
Get the parameter for a flexible server.". |
Core | GA |
| az postgres flexible-server private-endpoint-connection |
Manage PostgreSQL flexible server private endpoint connections. |
Core | GA |
| az postgres flexible-server private-endpoint-connection approve |
Approve the specified private endpoint connection associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-endpoint-connection delete |
Delete the specified private endpoint connection associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-endpoint-connection list |
List all private endpoint connections associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-endpoint-connection reject |
Reject the specified private endpoint connection associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-endpoint-connection show |
Show details of a private endpoint connection associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-link-resource |
Get Private link resource for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-link-resource list |
List private link resources associated with a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server private-link-resource show |
Get private link resource for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server replica |
Manage read replicas. |
Core | GA |
| az postgres flexible-server replica create |
Create a read replica for a server. |
Core | GA |
| az postgres flexible-server replica list |
List all read replicas for a given server. |
Core | 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. |
Core | GA |
| az postgres flexible-server restart |
Restart a flexible server. |
Core | GA |
| az postgres flexible-server restore |
Restore a flexible server from backup. |
Core | GA |
| az postgres flexible-server revive-dropped |
Revive a dropped flexible server from backup. |
Core | GA |
| az postgres flexible-server server-logs |
Manage server logs (log files) for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server server-logs download |
Download log files for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server server-logs list |
List log files for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server show |
Get the details of a flexible server. |
Core | GA |
| az postgres flexible-server show-connection-string |
Show the connection strings for a PostgreSQL flexible-server database. |
Core | GA |
| az postgres flexible-server start |
Start a flexible server. |
Core | GA |
| az postgres flexible-server stop |
Stop a flexible server. |
Core | GA |
| az postgres flexible-server update |
Update a flexible server. |
Core | GA |
| az postgres flexible-server upgrade |
Upgrade the major version of a flexible server. |
Core | GA |
| az postgres flexible-server virtual-endpoint |
Manage virtual endpoints for a PostgreSQL flexible server. |
Core | GA |
| az postgres flexible-server virtual-endpoint create |
Create a new virtual endpoint for a flexible server. |
Core | GA |
| az postgres flexible-server virtual-endpoint delete |
Delete a virtual endpoint. |
Core | GA |
| az postgres flexible-server virtual-endpoint list |
List all virtual endpoints for a flexible server. |
Core | GA |
| az postgres flexible-server virtual-endpoint show |
Get the details of a virtual endpoint. |
Core | GA |
| az postgres flexible-server virtual-endpoint update |
Update a virtual endpoint. |
Core | GA |
| az postgres flexible-server wait |
Wait for the flexible server to satisfy certain conditions. |
Core | GA |
