search

cyrilgdn / terraform-provider-postgresql

Terraform PostgreSQL provider
https://www.terraform.io/docs/providers/postgresql/
Mozilla Public License 2.0
355 stars 180 forks source link

Cannot perform plan in read-only mode (read-replica) - AWS RDS Global Cluster - non-writer #433

Open gdowmont-gss opened 2 months ago

gdowmont-gss commented 2 months ago

Hi,

I am using this provider in terraform configuration that uses RDS Global Cluster to failover between prod and prod-dr.

Each configuration is a separate component per env, so trying to perform even a basic plan is not possible on the non-writer cluster due to:


  with postgresql_extension.pgaudit_lm_configuration,
  on pgsql_extensions.tf line 1, in resource "postgresql_extension" "pgaudit":
   1: resource "postgresql_extension" "pgaudit" {

Same happens to roles, schema, etc

Is there some configuration I missing that would allow performing plans in read-only configuration without setting read-write mode?

Tried with 1.17.1 and 1.22.0