I am creating a DMS task to load data from RDS postgre to AWS s3. The DMS is creating a replication slot by default having a long alpha numeric slot name . Both Full load and CDC works fine with it .
I want to provide a useful name to the slot so that I can identify for which table it is being used for ? Now when I try to create a slot with the a custom name using the following query :
select * FROM pg_create_logical_replication_slot('slotname', 'test_decoding');
It is getting created. But the active flag is false .
select * from pg_replication_slots
Is there any way to make it active ?
And provide the slotName in DMS Endpoint configuration in Extra connection attributes slotName=slotname
