2 Answers
- Newest
- Most votes
- Most comments
0
We were finally able to find the solution:
Set datestyle only for the replication user:
ALTER USER my_replication_user SET datestyle='ISO, MDY';
For verifying whether the change has taken effect:
SELECT usename,useconfig FROM pg_catalog.pg_user WHERE usename='my_replication_user';
After making the above changes, restart the DMS task and that's all.
answered 2 years ago
0
Can you use Logical Replication (which is far better than DMS) to replicate instead? What is the target?
answered 2 years ago
Relevant content
- asked 7 months ago
- Accepted Answerasked 3 years ago
- asked a month ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago