DMS task fails when Postgres DateStyle parameter is not ISO
I need to replicate some tables from a Postgres 11.14 database on an Amazon EC2 instance with DMS.
When I start the DMS task, it fails and the log shows me that the problem has to do with the configuration of the parameter DateStyle in the source system (Postgres).
In the source this parameter is set to 'SQL, DMY' and DMS tells me that needs it set up to 'ISO' to do the replication.
2022-06-08T21:22:00 [SOURCE_CAPTURE ]E: Bad setting for 'DateStyle' parameter. WAL connection setup is expecting 'ISO'.  (postgres_endpoint_wal_engine.c:1341)
I cannot change this configuration in the source because there we have a Core that needs this parameter to be configured like that ('SQL, DMY').
Is there another way in which we can replicate without having to change this parameter?
Thanks in advance.
Can you use Logical Replication (which is far better than DMS) to replicate instead? What is the target?
DMS Migration MongoDB source and RDS Postgres as destinationAccepted Answerasked 18 days ago
Resolution for Fatal error when using DMS for on-going replication from RDS Postgres to S3Accepted Answerasked a year ago
ETL from an Oracle database into RDS Postgres too slowAccepted Answerasked 2 years ago
DMS task fails when Postgres DateStyle parameter is not ISOasked 25 days ago
does AWS DMS support partition tables from postgresasked 6 months ago
AWS DMS Replication Taskasked a month ago
Refactoring from Oracle to postgres, Do I need to drop foreign key constraitns at postgresasked 2 days ago
Using DMS CDC for Oracle to Postgresasked 4 days ago
DMS service for aurora postgres doesnt accept a view as source for full load processasked 3 months ago
Applying column filters in DMS Task for source MongoDB and target Postgresasked 17 days ago