Allow optional storage size with auto_grow enabled

[croissong]

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

We're experiencing an undesired behavior when enabling auto_grow for a postgresql server.
As the storage_mb setting is required, each time the storage size is automatically increased via autogrow, terraform detects a change and storage_mb needs to be manually increased as well.
Ideally, storage_mb would be optionally if auto_grow is enabled.

New or Affected Resource(s)

• azurerm_postgresql_server

Potential Terraform Configuration

resource "azurerm_postgresql_server" "db" {
...
  storage_profile {
    storage_mb            = var.storage_mb
    auto_grow             = "Enabled"
  }

[r0bnet]

Hey @croissong,

as a workaround i'd propose the following:

resource "azurerm_postgresql_server" "db" {
...
  storage_profile {
    storage_mb            = var.storage_mb
    auto_grow             = "Enabled"
  }

  lifecycle {
    ignore_changes = [storage_profile.storage_mb]
  }

Is that a viable option for you? Tbf I didn't test that but it might work.

[jemrobinson]

For anyone else facing this issue, I found that the following minor tweak to @r0bnet 's solution worked in Terraform v0.12.20.

  lifecycle {
    ignore_changes = [storage_profile[0].storage_mb]
  }

[ghost]

This has been released in version 2.7.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.7.0"
}
# ... other configuration ...

[ghost]

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 feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!