Skip to main content

PostgresqlFlexible


Resource Icon​

Resource Overview​

Azure Database for PostgreSQL Flexible Server is a scalable, fully managed open-source relational database service on Azure that provides a flexible server architecture. It is designed to support a range of workloads and applications that require more control over PostgreSQL environment configuration. With Flexible Server, customers can choose from various compute and storage options to meet their specific needs. It supports both single-node and high-availability configurations and offers multiple options for backup and disaster recovery.

Associated Resources​

Parent Resource​

Resource Setting Values​

  • version: The version of PostgreSQL Server to use - 11, 12, 13, 14

  • sku_name : The name of SKU for the Postgresql Server, Tier + compute generation + cores pattern - azurePostgresqlFlexibleSku

  • storage_mb : Max storage allowed for a Postgresql Flexible Server in MB - storageGB

  • admin_username : If the creation mode is default, the administrator login for the Postgresql Server, Only alphanumeric characters are allowed, Without the reserved words, 1 to 16 characters

  • admin_password : If the creation mode is default, the password associated with the administrator login, Contain 3 of the following: lowercase letters/uppercase letters/numbers/special characters, Cannot contain more than 3 consecutive alphanumeric characters in the login name, 8 to 128 characters

  • availability_zone : Specifies the Availability Zone. Possible values are 1, 2, 3 - 1 ~ 3

  • enable_high_availability : Enable high availability of Postgresql Flexible Server - true , false

  • backup_retention_days : The backup retention days for the Postgresql Flexible Server. Possible values are between 1 and 35 days - 1 ~ 35

  • geo_redundant_backup_enabled - true , false

  • public_network_access_enabled : Allow public network access for the Server - true , false

  • configuration

    • name : The setting of PostgreSQL Server parameter
    • param_value : Specifies the value of the Postgresql Flexible Server Configuration

  • database

    • charset : The charset for the Postgresql Database - azurePostgresqlChartSet
    • collation : The collation for the Postgresql Database - azurePostgresqlFlexibleCol

  • firewall_rule

    • start_ip_address : The Start IP Address asscociated with the Firewall Rule
    • end_ip_address : The End IP Address asscociated with the Firewall Rule

  • tag : Tag to categorize resources - up to 512 characters, key:value

Reference Materials​