last sync: 2025-Apr-29 17:44:12 Etc/UTC

PostgreSQL Server - Microsoft Azure Resource type
microsoft.dbforpostgresql/flexibleservers

Azure Resource Provider Resource provider (RP) - Microsoft DB for PostgreSQL [Microsoft.DBforPostgreSQL]
RP Microsoft.DBforPostgreSQL
RP display name Microsoft DB for PostgreSQL
Azure Resource Type
RP Resource types
Resource types: 100
Azure Policy Alias
RP aliases
RP aliases: 304
Azure Policy definition
RP Azure Policy
Azure Policy definitions: 57
if: 57
then.deployment: 4
then.details: 2
then.existenceCondition: 0
then.operations: 0
Azure RBAC Role Based Access Control
RP RBAC operations
RP RBAC operations: 172
RP RBAC operationType action: 34
RP RBAC operationType delete: 21
RP RBAC operationType read: 85
RP RBAC operationType write: 32
Azure RBAC Role definition
RP RBAC Roles & Operation actions
Unique RBAC Roles: 19
RBAC Roles with action operationType: 6
RBAC Roles with delete operationType: 4
RBAC Roles with read operationType: 19
RBAC Roles with write operationType: 5
Azure Application
RP related 1st party Service Principals
RP related 1st party Service Principals: 7
• Meru19 First Party App (Azure Database for PostgreSQL Flexible Server Private Network Integration) (appId: 93efed00-6552-4119-833a-422b297199f9)
• Azure SQL Virtual Network to Network Resource Provider (appId: 76cd24bf-a9fc-4344-b1dc-908275de6d6d) [ JSON;CSV]
• Azure OSSRDBMS PostgreSQL Flexible Server AAD Authentication (appId: 5657e26c-cc92-45d9-bc47-9da6cfdb4ed9) [ JSON;CSV]
• Azure OSSRDBMS Database (appId: 123cd850-d9df-40bd-94d5-c9f07b7fa203)
• Azure Database for PostgreSQL Marlin (appId: 5ed8fe41-c1bc-4c06-a531-d91e1f1c2fac)
• Azure CosmosDB for PostgreSQL Microsoft EntraId (appId: ecafc2d9-cf1a-49a7-b60f-e44e34a988d2)
• Azure CosmosDB for PostgreSQL AAD Authentication (appId: b4fa09d8-5da5-4352-83d9-05c2a44cf431)
All Azure RPs Microsoft Learn
AzResourceTypesAdvertizer (Microsoft only)
Azure Resource Type Resource type (RT) - PostgreSQL Server [microsoft.dbforpostgresql/flexibleservers]
RT information
RT microsoft.dbforpostgresql/flexibleservers
RT display name PostgreSQL Server
RT type only
(without RP)
flexibleServers
RT sub- Resource types sub-Resource types: 28
RT schema RT schema API versions: 12
All Microsoft Azure RTs AzResourceTypesAdvertizer
Aliases and Azure Policy
Azure Policy Alias
Aliases
aliases: 102
Azure Policy definition
Azure Policy
Azure Policy definitions: 29
if: 29
then.deployment: 1
then.details: 0
then.existenceCondition: 0
then.operations: 0
RBAC Operations and Roles & Roles related operation actions
Azure RBAC Role Based Access Control
RBAC operations
RBAC operations: 15
RBAC operationType action: 12
RBAC operationType delete: 1
RBAC operationType read: 1
RBAC operationType write: 1
Azure RBAC Role definition
RBAC Roles & Operation actions
Unique RBAC Roles: 19
RBAC Roles with action operationType: 5
RBAC Roles with delete operationType: 4
RBAC Roles with read operationType: 18
RBAC Roles with write operationType: 4
Capabilities & Locations
Azure Resource Diagnostic settings logs
Diagnostic logs
True
log-categories
Azure Resource Diagnostic settings metrics
Diagnostic metrics
True
metrics
Azure Customer-managed key
Customer-managed key (CMK) [experimental]
Unknown
Enforce Encryption with a customer-managed key (CMK) at scale
Azure Managed identity
System-Assigned-Resource-Identity
True
Azure Resource Mover
Cross-ResourceGroup-Resource-Move
True
Azure Resource Mover
Cross-Subscription-Resource-Move
True
Azure Resource Tags
Tags
True
Azure Extension
Extension
False
Azure Private Endpoint
Private-Endpoint
True
Azure Private Endpoint location Azure Private Endpoint location
Supported Locations for Private-Endpoint
Supported Locations for Private-Endpoint: 44
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, jioindiawest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
Non supported Locations for Private-Endpoint Non supported Locations for Private-Endpoint: 14
brazilus, eastusstg, centraluseuap, eastus2euap, southcentralusstg, southafricawest, australiacentral2, jioindiacentral, francesouth, germanynorth, norwaywest, switzerlandwest, uaecentral, brazilsoutheast
Azure location
Location
True
Azure Resource type location Azure Resource type location
Locations
Locations: 43
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, francesouth, germanywestcentral, israelcentral, italynorth, japaneast, japanwest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, switzerlandwest, uaenorth, uksouth, ukwest, westcentralus, westeurope, westus, westus2, westus3
Not locations Not locations: 54
asia, asiapacific, australia, australiacentral2, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, germany, germanynorth, global, india, indonesia, indonesiacentral, israel, italy, japan, jioindiacentral, jioindiawest, korea, mexico, newzealand, northcentralusstage, norway, norwaywest, poland, qatar, singapore, southafrica, southafricawest, southcentralusstage, southcentralusstg, southeastasiastage, spain, sweden, switzerland, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westindia, westus2stage, westusstage
Assessment tooling
Azure Advisor
Azure Advisor
Azure Advisor recommendations: 19
HighAvailability [High] Create a read replica from the Azure Database for PostgreSQL flexible server
HighAvailability [High] Remove inactive logical replication slots (important)
HighAvailability [Medium] Configure geo redundant backup storage
HighAvailability [Medium] Support for Azure Database for PostgreSQL Flexible Server version 11 is being retired.
Performance [High] Review your server approaching wraparound
Performance [High] Review your server for autovacuum turned OFF
Performance [High] Review your server for bloat ratio greater than 80%
Performance [High] Review your server for high CPU utilization
Performance [High] Review your server for inactive Logical Replication Slots
Performance [High] Review your server for log_min_duration_statement turned ON
Performance [High] Review your server for log_statement_stats turned ON
Performance [High] Review your server for long running transactions
Performance [High] Review your server for orphaned prepared transactions
Performance [High] Review your server for too frequent checkpoints
Performance [Medium] Review your server for log_duration turned ON
Performance [Medium] Review your server for log_error_verbosity set to VERBOSE
Performance [Medium] Review your server for log_statement set to ALL
Security [High] Microsoft Defender for SQL should be enabled for unprotected PostgreSQL flexible servers
Security [Medium] Azure Database for PostgreSQL flexible server should have Microsoft Entra authentication only enabled
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 recommendations: 5
DisasterRecovery [High] Configure geo redundant backup storage
DisasterRecovery [High] Configure one or more read replicas
HighAvailability [High] Enable HA with zone redundancy
Scalability [High] Enable custom maintenance schedule
Scalability [High] Configure storage auto-grow
PSRule for Azure
PSRule for Azure
PSRule for Azure rules: 5
Reliability [Important] Configure geo-redundant backup
Reliability [Important] Customer-controlled maintenance window configuration
Reliability [Important] Zone-Redundant High Availability
Security [Critical] Use Entra ID authentication with PostgreSQL databases
Security [Important] Entra ID only authentication with PostgreSQL databases
Azure Quick Review (AZQR)
Azure Quick Review (AZQR)
Azure Quick Review (AZQR) recommendations: 9
DisasterRecovery [High] Configure geo redundant backup storage
DisasterRecovery [High] Configure one or more read replicas
Governance [Low] PostgreSQL Name should comply with naming conventions
Governance [Low] PostgreSQL should have tags
HighAvailability [High] Enable HA with zone redundancy
HighAvailability [High] PostgreSQL should have a SLA
MonitoringAndAlerting [Low] PostgreSQL should have diagnostic settings enabled
Scalability [High] Enable custom maintenance schedule
Security [High] PostgreSQL should have private access enabled
Infrastructure as Code (IaC)
ARM (Azure Resource Manager)
ARM (Azure Resource Manager) templates
ARM (Azure Resource Manager) template API versions: 12
latest
Azure Bicep
Bicep templates
Bicep template API versions: 12
latest
Terraform
Terraform provider
Terraform providers: 1
postgresql_flexible_server
AzAPI Terraform
AzAPI Terraform templates
AzAPI Terraform template API versions: 12
latest
Pulumi
Pulumi provider
Pulumi providers: 1
dbforpostgresql/server
OpenTofu
OpenTofu provider
OpenTofu TF providers: 1
postgresql_flexible_server
Azure Verified Modules (AVM) Bicep Azure Verified Modules (AVM) Bicep
Azure Verified Modules (AVM) Bicep
DB for Postgre SQL Flexible Server
Azure Verified Modules (AVM) Terraform Azure Verified Modules (AVM) Terraform
Azure Verified Modules (AVM) Terraform
• GitHub: DB for Postgre SQL Flexible Server
• Terraform registry: DB for Postgre SQL Flexible Server
REST-API (Representational State Transfer - Application Programming Interface)
REST-API versions REST-API versions: 20
2025-01-01-preview
2024-11-01-preview
2024-08-01
2024-05-01-privatepreview
2024-03-01-privatepreview
2023-12-01-preview
2023-06-01-preview
2023-03-01-preview
2023-01-01-privatepreview
2022-12-01
2022-11-01-preview
2022-05-01-privatepreview
2022-05-01-preview
2022-03-08-privatepreview
2022-03-08-preview
2022-01-20-preview
2021-06-01-preview
2021-06-01
2020-02-14-privatepreview
2020-02-14-preview
REST-API version default n/a
API profiles n/a
Resource naming
Azure Naming Tool
Azure Naming Tool
The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.
Resource naming details n/a