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โ€‹

ExtractTypeFlags
๐Ÿ”Œ 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