Different backend
In order to change Terraform's backend provider from PostgresQL to something else you need to manually dig into source code and change infra/backend.tf
file.
infra/backend.tf
# default
terraform {
backend "pg" {}
}
For available customization options, please refer to this Terraform's Backend block configuration overview guide.
warning
Keep in mind that default approach uses TF_BACKEND_PG_CONN_STR
environment variable to populate backend connection string. If you change backend to different type, you'll have to provide values by yourself.