#Problems with PostgreSQL Flexible Server and Terraform

1 messages · Page 1 of 1 (latest)

spare flower
#

There seems to be an issue with version in Terraform.

I am trying to setup a server like this :

resource "azurerm_postgresql_flexible_server" "example" {
  name                   = var.postgresql_server_name
  resource_group_name    = var.resource_group_name
  location               = var.location
  version                = var.postgresql_version
  delegated_subnet_id    = var.subnet_id
  private_dns_zone_id    = azurerm_private_dns_zone.dns_zone.id
  administrator_login    = var.administrator_login
  administrator_password = var.administrator_password
  zone                   = var.zone

  storage_mb = var.storage_mb

  sku_name   = var.sku_name
  depends_on = [azurerm_private_dns_zone_virtual_network_link.example]
}

I am getting this error :

│ Error: creating Flexible Server (Subscription: "redacted"
│ Resource Group Name: "mytestaksatgf"
│ Flexible Server Name: "chaosdb"): performing Create: servers.ServersClient#Create: Failure sending request: StatusCode=0 -- Original Error: Code="ParameterOutOfRange" Message="The value of the 'Version' should be in: []. Verify that the specified parameter value is correct."
│
│   with module.db.azurerm_postgresql_flexible_server.example,
│   on modules/database/main.tf line 13, in resource "azurerm_postgresql_flexible_server" "example":
│   13: resource "azurerm_postgresql_flexible_server" "example" {

My postgresql_version variable is set to "14". I have tried to put it in a list like the error suggests and i have tried a different version (12).

When i put it in a list mike this version = [var.postgresql_version] i get this error :

│ Error: Incorrect attribute value type
│
│   on modules/database/main.tf line 17, in resource "azurerm_postgresql_flexible_server" "example":
│   17:   version                = [var.postgresql_version]
│     ├────────────────
│     │ var.postgresql_version is a string
│
│ Inappropriate value for attribute "version": string required.```
#

I am using the latest azurerm version (3.60.0)

#

Found the issue :

For prices please refer to https://aka.ms/postgres-pricing
[]```