Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
gdowmont-gss opened this issue Apr 24, 2024 · 0 comments

Comments

@gdowmont-gss
Copy link

gdowmont-gss commented Apr 24, 2024

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:

Error: could not start transaction: pq: cannot set transaction read-write mode during recovery

  with postgresql_extension.pgaudit_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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant