Is it possible to do log based cdc on a postgres read replica?

[john_wang]

Hello @jmiao ,

Welcome to Qlik Community forum and thanks for reaching out here!

It's hard to tell this time based on the information provided. Could you please let us know detailed information about the secondary nodes?

Please be aware of the following limitation: To capture changes from a secondary database, read/write privileges must be configured on the databa....

BTW, the wal_level must be set to logical in the node (primary, or replica).

Hope this helps.

Regards,

John.

[dowre70]

One thing I'll point out is that the indexes that work for your operational workloads may not be sufficient to cover the analytical queries, so it's not necessarily clear that just mirroring the indexes is the right solution.