topic Postgres manually set the name of the replication slot in Qlik Automate

Postgres manually set the name of the replication slot

VladimirPashchenko — Mon, 23 Jan 2023 14:13:08 GMT

Postgres - is it possible to manually set the name of the replication slot on the Qlick. Instead of auto-generated like 'some_base_00017430_bcbc805f_aae1_b140_9ba6_866a882b819f'.

Thanks.

Re: Postgres manually set the name of the replication slot

ArmandoVBA — Tue, 31 Jan 2023 10:40:34 GMT

I think you can do this by specifying the replication_slot_name option when creating the replication slot using the pg_create_physical_replication_slot function.

Re: Postgres manually set the name of the replication slot

VladimirPashchenko — Tue, 31 Jan 2023 10:55:46 GMT

Our Postgres admins want to manually create replication slots. Can I set the name of the slot in Qlick? without its automatic creation. For example cdc_qlik_some_base

Re: Postgres manually set the name of the replication slot

RogerBeanPool — Sun, 05 Nov 2023 12:13:06 GMT

Configure the Internal Parameter

slotName

Referenced: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-task-error-Can-t-resume-task-after-replication/ta-p/2045816