I am following this documentation https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Security to enable CDC using logical replication.

I have pglogical extension installed and added under "shared_preload_libraries" parameter. Replication slot created fine - SELECT * FROM pg_create_logical_replication_slot('test_slot', 'pglogical');

but why do i get this error when creating replication set as exactly mentioned in the document?

select pglogical.create_replication_set('test_slot', false, true, true, false);
ERROR:  current database is not configured as pglogical node
HINT:  create pglogical node first

However, Creating pglogical node step is ONLY covered under a different topic of "Using native CDC..." in the same URL - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.v10

Can someone please explain the right steps on how to enable logical replication via AWS DMS CDC?

is native cdc different than DMS CDC?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.