Unable to use plugins to establish logical replication on source PostgreSQL

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

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

Here are steps required for AWS managed PostgreSQL database:

• The admin user account has the required roles that allow it to set up CDC. If you use an account other than the admin user account, the account must have the rds_superuser role and the rds_replication role. The rds_replication role grants permissions to manage logical slots and to stream data using logical slots.
• rds.logical_replication parameter in your DB CLUSTER parameter group to 1
• wal_sender_timeout DMS requires a minimum of 10000 milliseconds (10 seconds), and fails if the value is between 0 and 10000.
• shared_preload_libraries should include pglogical