Unable to use plugins to establish logical replication on source PostgreSQL
Full Load, ongoing replication data migration from postgres to postgres RDS using Data Migration Service.
Migration task is failing and throwing the below error:
Last Error: Unable to use plugins to establish logical replication on source PostgreSQL instance. Follow all prerequisites for 'PostgreSQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:XXXX] Remaining 1 error messages are truncated. Check the task log to find details Stop Reason FATAL_ERROR Error Level FATAL
Any suggestion or ideas are welcome. Thanks in advance!
Have you found out the problem?
I'm actually seeing the same issue. The only resource I could come up with is this: https://stackoverflow.com/questions/44018819/aws-dms-streaming-replication-logical-decoding-output-pluginstest-decoding-n
This static parameter requires a reboot of the DB instance to take effect.
So reboot your RDS instance after making the paramater group change and you should be all set.
Edited by: rseedfi on Jun 30, 2021 8:30 PM
Resolution for Fatal error when using DMS for on-going replication from RDS Postgres to S3Accepted Answerasked a year ago
Unable to use plugins to establish logical replication on source PostgreSQLasked 2 years ago
RDS PostgreSQL cascading replication for Fivetran integration (logical replication not working on replica)asked 13 days ago
AWS data migration service task, Load complete, replication ongoing, but no rows loaded in redshift or shown in Table statisticsasked 5 months ago
Aurora Postgres 13 with IAM Auth - Unable to establish logical replication connectionasked 6 months ago
DMS service for aurora postgres doesnt accept a view as source for full load processasked 2 months ago
Migration from Aurora PostgreSQL back to regular RDSAccepted Answerasked 3 years ago
RDS Postgres Logical replication access to essential table deniedAccepted Answerasked 3 years ago
Does AWS DMS support ARRAY data type for RDS for PostgreSQL on EC2 to Aurora PostgreSQL migration?Accepted Answerasked 2 years ago
Postgres RDS Schema Upgrade (migration) with no downtimeasked 2 months ago