AWS Blue/Green Postgres - default_transaction_read_only not applying for Green deployment
Hello community, After we've setting up green deployment we noticed that parameter "default_transaction_read_only" in the DB parameter groups didn't work properly (we have disabled this parameter, but in the DB we still seeing an error, and cannot use write operations) any suggestions?
- 最新
- 最多得票
- 最多評論
On a green instance the value is set to read_only so that you do not make unintended changes to green that would break logical replication to green. You can however change the value in a session variable if you need to make writes to green.
You prepare a new parameter group and set defalut_transaction_read_only to 0 for that parameter group. You can then apply the parameter group to the Green environment and restart it to maintain the database on the Green side. Alter System is not available on Aurora.
相關內容
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前