Terraform为azure Postgressql灵活服务器引发错误配置数据库角色

Question

我使用terraform将Azure PostgresSQL灵活服务器部署为PAAS，运行良好。现在，我希望创建不同的角色，并使用terraform为数据库分配不同的特权。但这就提高了下面提到的误差。请看一看，并建议我适当的地形配置和所需的供应商为解决方案。

Error: Failed to query available provider packages

Could not retrieve the list of available versions for provider hashicorp/postgresql: provider registry registry.terraform.io does not have a provider named registry.terraform.io/hashicorp/postgresql
Did you intend to use cyrilgdn/postgresql? If so, you must specify that source address in each module which requires that provider. To see which modules are currently depending on hashicorp/postgresql, run the following command:
terraform provider

terraform {
  required_version = ">= 1.1.6"
  required_providers {
    azurerm = {
      source  = "hashicorp/azurerm"
      version = ">=3.20.0"
    }

    postgresql = { 
      source  = "cyrilgdn/postgresql"
      version = "1.15.0"
    }

  }
}

provider "postgresql" {
  host            = module.az_pssql_flex.azurerm_postgresql_flexible_server
  port            = 5432
  database        = var.databases_names
  username        = ""
  password        = ""
  sslmode         = "require"
  connect_timeout = 120
  superuser       = false

}

​

​

Answer 1

使用terraform为数据库创建不同角色和分配不同权限的解决方案。

1. 在子模块中创建了一个"provider.tf“文件并定义了pssql模块

。

1. 定义根模块porvider.tf文件旁边的postgresql提供程序块.

1. ​

1. run terraform plan

1. run应用.