In-place upgrades for cloudsql resources

[songalbert]

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. If the issue is assigned to the "modular-magician" user, it is either in the process of being autogenerated, or is planned to be autogenerated soon. If the issue is assigned to a user, that user is claiming responsibility for the issue. If the issue is assigned to "hashibot", a community member has claimed the issue already.

Description

Terraform created cloudsql databases should be able to be upgraded in-place without causing issues of duplicate resources or hardcoded database versions. With the GCP console in-place upgrade feature available, it can cause problems if you are using terraform for your cloudsql maintenance.

New or Affected Resource(s)

google cloudsql postgres

Potential Terraform Configuration

# Propose what you think the configuration to take advantage of this feature should look like.
# We may not use it verbatim, but it's helpful in understanding your intent.

References

• #0000

[rileykarson]

@shuyama1 to assess feasibility

[shuyama1]

@songalbert Sorry for the late investigation on this issue. It seems like we recently implemented the functionality of in-place major version upgrade for sql instance (GoogleCloudPlatform/magic-modules#6374). The feature is released in version 4.34.0. Is this something you are looking for?

[shuyama1]

Closing this issue as it may have already implemented. Feel free to reopen this issue or create a new one if you think the feature is not yet supported in the providers.

[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.