RT information
| RT |
microsoft.dbforpostgresql/servers
|
| RT display name |
PostgreSQL Server
|
RT type only
(without RP) |
servers
|
| RT sub- Resource types |
sub-Resource types: 23
|
| RT schema |
RT schema API versions: 2
• 2017-12-01-preview
• 2017-12-01
|
| All Microsoft Azure RTs |
AzResourceTypesAdvertizer |
Aliases and Azure Policy
Aliases |
aliases: 23
|
Azure Policy |
Azure Policy definitions: 24
• if: 24
• then.deployment: 2
• then.details: 0
• then.existenceCondition: 0
• then.operations: 0
|
RBAC Operations and Roles & Roles related operation actions
RBAC operations |
RBAC operations: 8
• RBAC operationType action: 5
• RBAC operationType delete: 1
• RBAC operationType read: 1
• RBAC operationType write: 1
|
RBAC Roles & Operation actions |
Unique RBAC Roles: 17
• RBAC Roles with action operationType: 4
• RBAC Roles with delete operationType: 4
• RBAC Roles with read operationType: 17
• RBAC Roles with write operationType: 4
|
Capabilities & Locations
Diagnostic logs |
True
log-categories
|
Diagnostic metrics |
True
metrics
|
Customer-managed key (CMK) [experimental] |
Unknown
• Enforce Encryption with a customer-managed key (CMK) at scale
|
System-Assigned-Resource-Identity |
True
|
Cross-ResourceGroup-Resource-Move |
True
|
Cross-Subscription-Resource-Move |
True
|
Tags |
True
|
Extension |
False
|
Private-Endpoint |
True
|
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
|
Location |
True
|
Locations |
Locations: 38
australiacentral, australiacentral2, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, francesouth, germanywestcentral, japaneast, japanwest, koreacentral, koreasouth, northcentralus, northeurope, norwayeast, southafricanorth, southafricawest, southcentralus, southeastasia, southindia, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
|
| Not locations |
Not locations: 59
asia, asiapacific, australia, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, germany, germanynorth, global, india, indonesia, indonesiacentral, israel, israelcentral, italy, italynorth, japan, jioindiacentral, jioindiawest, korea, mexico, mexicocentral, newzealand, newzealandnorth, northcentralusstage, norway, norwaywest, poland, polandcentral, qatar, qatarcentral, singapore, southafrica, southcentralusstage, southcentralusstg, southeastasiastage, spain, spaincentral, sweden, switzerland, switzerlandwest, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westus2stage, westusstage
|
|
|
Assessment tooling
Azure Advisor |
Azure Advisor recommendations: 10
|
Azure Proactive Resilience Library v2 (APRLv2) |
n/a
|
PSRule for Azure |
PSRule for Azure rules: 9
|
Azure Quick Review (AZQR) |
Azure Quick Review (AZQR) recommendations: 7
• Governance [Low] PostgreSQL Name should comply with naming conventions
• Governance [Low] PostgreSQL should have tags
• HighAvailability [High] PostgreSQL should have a SLA
• MonitoringAndAlerting [Low] PostgreSQL should have diagnostic settings enabled
• Security [High] PostgreSQL should enforce SSL
• Security [High] PostgreSQL should have private endpoints enabled
• Security [Low] PostgreSQL should enforce TLS >= 1.2
|
REST-API (Representational State Transfer - Application Programming Interface)
| REST-API versions |
REST-API versions: 2
• 2017-12-01-preview
• 2017-12-01
|
| REST-API version default |
n/a
|
| API profiles |
n/a
|
Resource naming
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 |
{
"property": "",
"ShortName": "psql",
"scope": "global",
"lengthMin": "3",
"lengthMax": "63",
"validText": "Lowercase letters, hyphens and numbers.",
"invalidText": "Can't start or end with hyphen.",
"invalidCharacters": "",
"invalidCharactersStart": "-",
"invalidCharactersEnd": "-",
"invalidCharactersConsecutive": "",
"regx": "^(?!-.*)(?!.*-$)[a-z0-9-]{3,63}$",
"staticValues": ""
}
|
|
Resource provider (RP) - Microsoft DB for PostgreSQL [Microsoft.DBforPostgreSQL]
