'RDS session_replication_role in paramater group is not being applied to all sessions
I've just finished migrating some postgres RDS instances from 9.6 to 12.8 using AWS DMS. After changing the session_replication_role back from replica to origin on the instances that were previously targets (using the parameter groups), I've realised foreign key constraints and triggers are not being enforced for all users (only the master account).
For instance, show session_replication_role
returns a value of origin
for the master account, but replica
for the users our applications connect to the various dbs with. The parameter group is showing as being synced and I've gone through a couple of reboots just to make sure. Anyone have any idea about why this is occurring or encountered this issue before?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|