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년 전
