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?
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a 5 mois
- demandé il y a un an
AWS OFFICIELA mis à jour il y a un an- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans