docs(cloudsql): add POSTGRES_16 to version list

[jenewland1999]

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 an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Description

Similar to #14864. It is possible to specify v16, but it is missing from the documentation. PostgreSQL version 16 went GA on June 07 2024.

New or Affected Resource(s)

• google_sql_database_instance

Potential Terraform Configuration

resource "google_sql_database_instance" "main" {
  name             = "main-instance"
  database_version = "POSTGRES_16"
  region           = "us-central1"

  settings {
    # Second-generation instance tiers are based on the machine
    # type. See argument reference below.
    tier = "db-f1-micro"
  }
}

References

No response

b/369163441

[BBBmau]

Hi @jenewland1999, currently POSTGRES_16 is not supported based on the API Docs, is this a field that has already been added in and is just missing a documentation update?

[jenewland1999]

Hi @jenewland1999, currently POSTGRES_16 is not supported based on the API Docs, is this a field that has already been added in and is just missing a documentation update?

It would seem their docs are outdated too 😅. However, I can confirm that creating a DB with v16 is indeed possible using the API. Funnily enough, in their API Explorer if you bring up the autocomplete dropdown it seems to suggest that both v16 and v17 are valid options.

[BBBmau]

@jenewland1999 this is a valid request then! Wanna open a PR that adds it in?