Best practice for postgres to aurora postgress task setting

[Ashs]

I am looking for best practice for postgres rds to aurora postgres replication? Do we create our slot name and use it or let qlik create by default? How to find out SCN/LCN from attrep_txn_state checkpoing what is the format of it?

[OritA]

Hi, 

In general the instructions on how to set the different endpints to work with Replicate can be found in the Replicate users guide. Specifically in your case here is the link to the chapter related to postgres source:
https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/PostgreSQL/postgresql_source.ht...

and here is the link to the section related to postgres target:
https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/PostgreSQL/postgresql.htm#ar_po...

Regarding how to find your SCN please refer to the Replicate Users guide under the following documentation section:
https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedEMReplicate/Tasks%...

Regards,

Orit

[DesmondWOO · Accepted solution]

Hi @Ashs ,

I recommend allowing Qlik to create the slot. If you create the slot manually, you'll need to add an internal parameter called "slotName" with your chosen slot name.

The format of the LSN is as follows: 0/10BCFCB0. You can find it in the CHECKPOINT column by querying attrep_txn_statetable.

Regards,
Desmond

[Ashs]

Thank you very much for the reply. I have some further queries. If I create a separate task and use it instead of original one (a copy of existing), in that case it asks to use slotNumber. In that case I wanted to have a slotNumber which should have specific name, but one created by Qlik will work.

   My checkpoint is like - 

checkpoint:V1#68155795#00000176/XXXXXXXX.132052.00000176/YYYYYYYY#0#66538485#00000176/ZZZZZZZZ.153.00000176/XZXZXZXZ#0#66538693 and that confused me on how to get LSN.

Also if I go to target and check LSN in we have two columns restart_lsn & confirmed_flush_lsn. Which one of these columncan be used to restart the task?

Thank you!