Support for Postgres Version 12

[Theaxiom]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

There is currently no support for Postgres version 12, I am creating a merge request to add support.

New or Affected Resource(s)

• azurerm_postgresql_server

Potential Terraform Configuration

resource "azurerm_resource_group" "example" {
  name     = "example-resources"
  location = "West Europe"
}

resource "azurerm_postgresql_server" "example" {
  name                = "example-psqlserver"
  location            = azurerm_resource_group.example.location
  resource_group_name = azurerm_resource_group.example.name

  administrator_login          = "psqladminun"
  administrator_login_password = "H@Sh1CoR3!"

  sku_name   = "GP_Gen5_4"
  version    = "12"
  storage_mb = 640000

  backup_retention_days        = 7
  geo_redundant_backup_enabled = true
  auto_grow_enabled            = true

  public_network_access_enabled    = false
  ssl_enforcement_enabled          = true
  ssl_minimal_tls_version_enforced = "TLS1_2"
}

References

https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/postgresql_server#version

• #0000

[Theaxiom]

I have submitted a merge request, please merge ASAP! Thank you!

[Theaxiom]

I just found out version 12 of Postgres is not yet supported in Azure, I am opening a support ticket with them to implement it.

[Theaxiom]

FYI: We opened a ticket with Microsoft Azure, apparently there is a new product which is in preview, called Flexible Server. Support for Terraform is coming in March/April and we are to proceed with this solution. It seems that version 12 of PostgreSQL is unlikely to be supported by Azure in the future, unless using Flexible Server.

[ghost]

This has been released in version 2.57.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.57.0"
}
# ... other configuration ...

[github-actions]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.