By using AWS re:Post, you agree to the Terms of Use
/Unable to use plugins to establish logical replication on source PostgreSQL/

Unable to use plugins to establish logical replication on source PostgreSQL

0

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!

3 Answers
0

Have you found out the problem?

answered a year ago
0

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

answered a year ago
0

Reading the docs:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.RDSPostgreSQL

It says:

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

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions