Terraform support for point on time server restore for Azure managed PostgreSQL

[singitamkr]

Hi,
We are using terraform for our couple cluster deployment for our product in MS Azure. But, in case of managed PostgreSQL, when we do a parallel upgrades we are not able to restore an existing PostgreSQL DB to a new instance with point in time restore option. Azure cli supports the same as below command. Azure managed PostgreSQL server restore (point in time) is not supported in terraform at present.

./az postgres server restore -g DatabaseTestingnPOC -n NewPrimary -s primary --restore-point-in-time "2020-03-17T16:50:30.0000Z"

Can you please help in getting this through terraform.

Thanks best regards
Krishna
Official email - [email protected]

[duaneguthrie]

to add on here:
azure sql db has https://www.terraform.io/docs/providers/azurerm/r/sql_database.html with "create_mode" = "restore"

we need similar api for PostgreSql https://docs.microsoft.com/en-us/rest/api/postgresql/databases/createorupdate

[njuCZ]

I am working on this issue

[duaneguthrie]

thanks so much

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