Using Postgres database as source

[gseckin]

Hi, 

We use postgres as source on qlik replicate. To fetch cdc changes, we created proper table under our schema -table attrep_ddl_audit table name -  to create ddl artifacts. We also configure this schema in advance section. The task is able to get cdc changes. But the table we created is still empty. And when I try to use advance run options go 5 mins ago and try for example, I get this error. Could you please help us to fix this, we need to use advance run option.

[john_wang]

Hello @gseckin ,

For a PostgreSQL source endpoint, 

• The “Start Process Changes from Timestamp” run option is not supported.

This limitation is documented in the User Guide.
Please configure the task to start processing changes from an LSN instead of a timestamp.

Hope this helps.

John.

[DesmondWOO]

Hi @gseckin ,

When Qlik Replicate creates a logical replication slot, it begins streaming changes from the current WAL position at the time of creation. You cannot start from an earlier point (e.g., five minutes ago). In addition, once changes have been consumed, the slot cannot be moved backward to re‑read them.

Regards,
Desmond