terraform progresql create role

[Mike-Hawkins]

Terraform Version

Terraform v0.12.28
+ provider.postgresql v1.7.0
+ provider.random v2.3.0

Terraform Configuration Files

default.tf

provider "postgresql" {
  alias = "pg"
  host            = "tester.amazonaws.com"
  database        = "postgres"
  username        = "master"
  password        = "password"
  expected_version = "12.3"
}

resource "random_id" "password" {
  byte_length = 16
}

resource "postgresql_role" "default" {
  provider = "postgresql.pg"
  name = "tester_user"
  login = true
  password = random_id.password.hex
  encrypted_password = false
  inherit = false
}

Debug Output

Crash Output

Crash.log

Expected Behavior

Terraform should have created the role within the database

Actual Behavior

Crashing on terraform apply but, not on terraform plan

Steps to Reproduce

terraform init
terraform apply

Additional Context

The user that is being used for the role creation does have proper permissions to log into the database and create users

References

[ghost]

This issue has been automatically migrated to hashicorp/terraform-provider-postgresql#163 because it looks like an issue with that provider. If you believe this is not an issue with the provider, please reply to hashicorp/terraform-provider-postgresql#163.

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