Skip to main content

📗 Azure PostgreSQL Server

  • Contextual name: 📗 Azure PostgreSQL Server
  • ID: /types/CA10Z1__CaAzurePostgreSqlServer__c

Fields

LabelAPI NameTypeHelp
🔒Administrator User NameCA10Z1__administratorUserName__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒🧮ApplicationCA10Z1__application__cText(1300)
🔒Application Tier Api NameCA10Z1__applicationTierApiName__cText(255)
🔒Application Tier Cascade AttachCA10Z1__applicationTierCascadeAttach__cCheckbox
🔒Application Tier Client NameCA10Z1__applicationTierClientName__cText(255)
🔒Application Tier Parent TypeCA10Z1__applicationTierParentType__cText(255)
🔒Application Tier Parent UUIDCA10Z1__applicationTierParentUuid__cText(255)
🔒Application Tier Unique NameCA10Z1__applicationTierUniqueName__cText(255)
🔒Auth Config: Active Directory Auth StateCA10Z1__authConfigActiveDirectoryAuthState__cText(255)
🔒Auth Config: Password Auth StateCA10Z1__authConfigPasswordAuthState__cText(255)
🔒Auth Config: Tenant IDCA10Z1__authConfigTenantId__cText(255)
🔒Availability ZoneCA10Z1__availabilityZone__cText(255)
🔒Azure PostgreSQL Server NameNameText(80)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒BYOK EnforcementCA10Z1__byokEnforcement__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Backup: Earliest Restore DateCA10Z1__backupEarliestRestoreDate__cDateTimeAPI Call: Microsoft.DBforPostgreSQL/servers/read
🔒Backup: Geo Redundant StatusCA10Z1__backupGeoRedundantStatus__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Backup: Retention DaysCA10Z1__backupRetentionDays__cNumber(18, 0)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒CloudAware UUIDCA10Z1__caUuid__cText(36)
🔒🔌ConfigurationsCA10Z1__configurations__cLongTextArea(131072)Inline Help: JSON Document
API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Cost: 30-DayCA10Z1__cost30d__cCurrency(18, 2)
🔒Cost: MTDCA10Z1__costMtd__cCurrency(18, 2)
🔒Create ModeCA10Z1__createMode__cText(255)
🔒Created DateCreatedDateDateTime
🔒Data Encryption: Primary Key URICA10Z1__dataEncryptionPrimaryKeyUri__cText(255)
🔒Data Encryption: Primary User AssignedIdCA10Z1__dataEncryptionPrimaryUserAssignedId__cText(255)
🔒Data Encryption: TypeCA10Z1__dataEncryptionType__cText(255)
🔒Delegated Subnet Resource IDCA10Z1__delegatedSubnetResourceId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒DeletedIsDeletedCheckbox
🔒Deleted From AzureCA10Z1__disappearanceTime__cDateTime
🔒🔌Deployment ModeCA10Z1__deploymentMode__cText(255)
🔒Earliest Restore DateCA10Z1__earliestRestoreDate__cDateTime
🔒🔌Firewall RulesCA10Z1__firewallRules__cLongTextArea(131072)Inline Help: JSON Document
API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Fully Qualified Domain NameCA10Z1__fullyQualifiedDomainName__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒High Availability: ModeCA10Z1__highAvailabilityMode__cText(255)
🔒High Availability: Standby Avail ZoneCA10Z1__highAvailabilityStandbyAvailZone__cText(255)
🔒High Availability: StateCA10Z1__highAvailabilityState__cText(255)
🔒Identity: Principal IDCA10Z1__identityPrincipalId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Identity: Tenant IDCA10Z1__identityTenantId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Identity: TypeCA10Z1__identityType__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒🔌Infrastructure EncryptionCA10Z1__infrastructureEncryption__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Last Modified DateLastModifiedDateDateTime
🔒Location NameCA10Z1__locationName__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Maintenance Window: Custom WindowCA10Z1__maintenanceWindowCustomWindow__cText(255)
🔒Maintenance Window: Day Of WeekCA10Z1__maintenanceWindowDayOfWeek__cNumber(18, 0)
🔒Maintenance Window: Start HourCA10Z1__maintenanceWindowStartHour__cNumber(18, 0)
🔒Maintenance Window: Start MinuteCA10Z1__maintenanceWindowStartMinute__cNumber(18, 0)
🔒Minimal TLS VersionCA10Z1__minimalTlsVersion__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Minor VersionCA10Z1__minorVersion__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Monitor: CPU Percent, 1-DayCA10Z1__monitorCpuPercentAvg01Day__cPercent(18, 2)
🔒Monitor: CPU Percent, 14-DayCA10Z1__monitorCpuPercentAvg14Day__cPercent(18, 2)
🔒Monitor: CPU Percent, 30-DayCA10Z1__monitorCpuPercentAvg30Day__cPercent(18, 2)
🔒Monitor: CPU Percent, 60-DayCA10Z1__monitorCpuPercentAvg60Day__cPercent(18, 2)
🔒Monitor: CPU Percent, 7-DayCA10Z1__monitorCpuPercentAvg07Day__cPercent(18, 2)
🔒Monitor: CPU Percent, 90-DayCA10Z1__monitorCpuPercentAvg90Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 1-DayCA10Z1__monitorIoConsumptionPercentAvg01Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 14-DayCA10Z1__monitorIoConsumptionPercentAvg14Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 30-DayCA10Z1__monitorIoConsumptionPercentAvg30Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 60-DayCA10Z1__monitorIoConsumptionPercentAvg60Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 7-DayCA10Z1__monitorIoConsumptionPercentAvg07Day__cPercent(18, 2)
🔒Monitor: IO Consumption Percent, 90-DayCA10Z1__monitorIoConsumptionPercentAvg90Day__cPercent(18, 2)
🔒Monitor: Lag Across Replicas Byte 1-DayCA10Z1__monitorLagAcrossReplicasByteMax01Day__cNumber(18, 0)
🔒Monitor: Lag Across Replicas Byte 14-DayCA10Z1__monitorLagAcrossReplicasByteMax14Day__cNumber(18, 0)
🔒Monitor: Lag Across Replicas Byte 30-DayCA10Z1__monitorLagAcrossReplicasByteMax30Day__cNumber(18, 0)
🔒Monitor: Lag Across Replicas Byte 60-DayCA10Z1__monitorLagAcrossReplicasByteMax60Day__cNumber(18, 0)
🔒Monitor: Lag Across Replicas Byte 7-DayCA10Z1__monitorLagAcrossReplicasByteMax07Day__cNumber(18, 0)
🔒Monitor: Lag Across Replicas Byte 90-DayCA10Z1__monitorLagAcrossReplicasByteMax90Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 1-DayCA10Z1__monitorLagAcrossReplicasMbMax01Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 14-DayCA10Z1__monitorLagAcrossReplicasMbMax14Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 30-DayCA10Z1__monitorLagAcrossReplicasMbMax30Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 60-DayCA10Z1__monitorLagAcrossReplicasMbMax60Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 7-DayCA10Z1__monitorLagAcrossReplicasMbMax07Day__cNumber(18, 0)
🔒🧮Monitor: Lag Across Replicas, MB, 90-DayCA10Z1__monitorLagAcrossReplicasMbMax90Day__cNumber(18, 0)
🔒Monitor: Memory Percent, 1-DayCA10Z1__monitorMemoryPercentAvg01Day__cPercent(18, 2)
🔒Monitor: Memory Percent, 14-DayCA10Z1__monitorMemoryPercentAvg14Day__cPercent(18, 2)
🔒Monitor: Memory Percent, 30-DayCA10Z1__monitorMemoryPercentAvg30Day__cPercent(18, 2)
🔒Monitor: Memory Percent, 60-DayCA10Z1__monitorMemoryPercentAvg60Day__cPercent(18, 2)
🔒Monitor: Memory Percent, 7-DayCA10Z1__monitorMemoryPercentAvg07Day__cPercent(18, 2)
🔒Monitor: Memory Percent, 90-DayCA10Z1__monitorMemoryPercentAvg90Day__cPercent(18, 2)
🔒Monitor: Replica Lag Seconds, 1-DayCA10Z1__monitorReplicaLagSecondsMax01Day__cNumber(18, 0)
🔒Monitor: Replica Lag Seconds, 14-DayCA10Z1__monitorReplicaLagSecondsMax14Day__cNumber(18, 0)
🔒Monitor: Replica Lag Seconds, 30-DayCA10Z1__monitorReplicaLagSecondsMax30Day__cNumber(18, 0)
🔒Monitor: Replica Lag Seconds, 60-DayCA10Z1__monitorReplicaLagSecondsMax60Day__cNumber(18, 0)
🔒Monitor: Replica Lag Seconds, 7-DayCA10Z1__monitorReplicaLagSecondsMax07Day__cNumber(18, 0)
🔒Monitor: Replica Lag Seconds, 90-DayCA10Z1__monitorReplicaLagSecondsMax90Day__cNumber(18, 0)
🔒Monitor: Storage Percent, 1-DayCA10Z1__monitorStoragePercentAvg01Day__cPercent(18, 2)
🔒Monitor: Storage Percent, 14-DayCA10Z1__monitorStoragePercentAvg14Day__cPercent(18, 2)
🔒Monitor: Storage Percent, 30-DayCA10Z1__monitorStoragePercentAvg30Day__cPercent(18, 2)
🔒Monitor: Storage Percent, 60-DayCA10Z1__monitorStoragePercentAvg60Day__cPercent(18, 2)
🔒Monitor: Storage Percent, 7-DayCA10Z1__monitorStoragePercentAvg07Day__cPercent(18, 2)
🔒Monitor: Storage Percent, 90-DayCA10Z1__monitorStoragePercentAvg90Day__cPercent(18, 2)
🔒Monitor: Storage Used, Bytes, 1-DayCA10Z1__monitorStorageUsedBytesAvg01Day__cNumber(18, 0)
🔒Monitor: Storage Used, Bytes, 14-DayCA10Z1__monitorStorageUsedBytesAvg14Day__cNumber(18, 0)
🔒Monitor: Storage Used, Bytes, 30-DayCA10Z1__monitorStorageUsedBytesAvg30Day__cNumber(18, 0)
🔒Monitor: Storage Used, Bytes, 60-DayCA10Z1__monitorStorageUsedBytesAvg60Day__cNumber(18, 0)
🔒Monitor: Storage Used, Bytes, 7-DayCA10Z1__monitorStorageUsedBytesAvg07Day__cNumber(18, 0)
🔒Monitor: Storage Used, Bytes, 90-DayCA10Z1__monitorStorageUsedBytesAvg90Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 1-DayCA10Z1__monitorStorageUsedMbAvg01Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 14-DayCA10Z1__monitorStorageUsedMbAvg14Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 30-DayCA10Z1__monitorStorageUsedMbAvg30Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 60-DayCA10Z1__monitorStorageUsedMbAvg60Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 7-DayCA10Z1__monitorStorageUsedMbAvg07Day__cNumber(18, 0)
🔒🧮Monitor: Storage Used, MB, 90-DayCA10Z1__monitorStorageUsedMbAvg90Day__cNumber(18, 0)
🔒NameCA10Z1__name__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒PostgreSQL Master Server IDCA10Z1__postgreSqlMasterServerId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Private DNS Zone Resource IDCA10Z1__privateDnsZoneResourceId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Private Endpoint ConnectionsCA10Z1__privateEndpointConnections__cLongTextArea(131072)
JSON
Inline Help: JSON Document
API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Public Network AccessCA10Z1__publicNetworkAccess__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Record IDIdText
🔒Replica CapacityCA10Z1__replicaCapacity__cNumber(18, 2)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Replication RoleCA10Z1__replicationRole__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Resource Group IDCA10Z1__resourceGroupId__cText(255)
🔒Resource IDCA10Z1__resourceId__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Restore Point In TimeCA10Z1__restorePointInTime__cDateTime
🔒SKU: CapacityCA10Z1__skuCapacity__cNumber(18, 2)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒SKU: FamilyCA10Z1__skuFamily__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒SKU: NameCA10Z1__skuName__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒SKU: SizeCA10Z1__skuSize__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒SKU: TierCA10Z1__skuTier__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒🔌SSL EnforcementCA10Z1__sslEnforcement__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒StateCA10Z1__state__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Storage Profile: Backup Retention DaysCA10Z1__storageProfileBackupRetentionDays__cNumber(18, 0)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Storage Profile: Geo Redundant BackupCA10Z1__storageProfileGeoRedundantBackup__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Storage Profile: Storage AutogrowCA10Z1__storageProfileStorageAutogrow__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒Storage Profile: Storage, MBCA10Z1__storageProfileStorageMb__cNumber(18, 0)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒System Data: Created AtCA10Z1__systemDataCreatedAt__cDateTime
🔒System Data: Created By IDCA10Z1__systemDataCreatedById__cText(255)
🔒System Data: Created By TypeCA10Z1__systemDataCreatedByType__cText(255)
🔒System Data: Last Modified AtCA10Z1__systemDataLastModifiedAt__cDateTime
🔒System Data: Last Modified By IDCA10Z1__systemDataLastModifiedById__cText(255)
🔒System Data: Last Modified By TypeCA10Z1__systemDataLastModifiedByType__cText(255)
🔒System ModstampSystemModstampDateTime
🔒Tag CountCA10Z1__tagCount__cNumber(18, 0)
🔒TagsCA10Z1__tags__cLongTextArea(131072)
🔒Tags JSONCA10Z1__tagsJson__cLongTextArea(131072)
🔒TypeCA10Z1__type__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒User Visible StateCA10Z1__userVisibleState__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read
🔒VersionCA10Z1__version__cText(255)API Call: Microsoft.DBforPostgreSQL/servers/read

Extracts

NameExtracts File
🔒CA10Z1__configurations__c🔌 object.extracts.yaml
🔒CA10Z1__deploymentMode__c🔌 object.extracts.yaml
🔒CA10Z1__firewallRules__c🔌 object.extracts.yaml
🔒CA10Z1__infrastructureEncryption__c🔌 object.extracts.yaml
🔒CA10Z1__sslEnforcement__c🔌 object.extracts.yaml
caJsonFrom__configurations__c🔌 object.extracts.yaml
caJsonFrom__firewallRules__c🔌 object.extracts.yaml

Lookups

LabelAPI NameType
🔒Application TierCA10Z1__applicationTier__c / CA10Z1__applicationTier__rCA10__CaApplicationTier__c
🔒Created By IDCreatedById / CreatedByUser
🔒Last Modified By IDLastModifiedById / LastModifiedByUser
🔒PostgreSQL Master ServerCA10Z1__postgreSqlMasterServer__c / CA10Z1__postgreSqlMasterServer__r📗 Azure PostgreSQL Server
🔒Received Connection IDConnectionReceivedId / ConnectionReceivedPartnerNetworkConnection
🔒Record Type IDRecordTypeId / RecordTypeRecordType
🔒ResourceCA10Z1__resource__c / CA10Z1__resource__r📗 Azure Resource
🔒Resource GroupCA10Z1__resourceGroup__c / CA10Z1__resourceGroup__rCA10__CaAzureResourceGroup__c
🔒Sent Connection IDConnectionSentId / ConnectionSentPartnerNetworkConnection
🔒SubscriptionCA10Z1__subscription__c / CA10Z1__subscription__r📗 Azure Subscription
Related TypeRelated List API NameForeign Key Field
🔒📗 Azure PostgreSQL ServerCA10Z1__Azure_PostgreSQL_Servers__rCA10Z1__postgreSqlMasterServer__c

Extract Files

ExtractParentyFlags
🔌 object.extracts.yaml📗 Azure PostgreSQL Server

Logic Files

LogicPolicyFlags
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Flexible Server connection_throttle.enable Parameter is not set to ON 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Flexible Server Firewall Rules allow access to Azure services 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Flexible Server log_checkpoints Parameter is not set to ON 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Flexible Server log_retention_days Parameter is less than 4 days 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Flexible Server require_secure_transport Parameter is not set to ON 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Single Server Enforce SSL Connection is not set enabled 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Single Server Infrastructure Double Encryption is not enabled 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Single Server log_connections Parameter is not set to ON 🟢🟢 x3
🧠 prod.logic.yaml 🟢📝 Azure PostgreSQL Single Server log_disconnections Parameter is not set to ON 🟢🟢 x3