https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2133565#M7913 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/165296">@jmiao</a>&nbsp;,</P> <P>Welcome to Qlik Community forum and thanks for reaching out here!</P> <P>It's hard to tell this time based on the information provided. Could you please let us know detailed information about the secondary nodes?</P> <P>Please be aware of the following limitation:&nbsp;<A title="To capture changes from a secondary database, read/write privileges must be configured on the database" href="https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedReplicateHDD/PostgreSQL-Source/limitations_postgresql_source.htm#ar_postgresds_802412600_1652565:~:text=as%20a%20source-,Limitations%20and%20considerations,PostgreSQL%20read%20replica%20(in%20a%20High%20Availability%20environment)%20is%20not%20supported.,-For%20information%20about" target="_blank" rel="noopener">To capture changes from a secondary database, read/write privileges must be configured on the database</A>.</P> <P>BTW, the&nbsp;<SPAN><A title="wal_level in the postgresql.conf configuration file" href="https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/PostgreSQL/prereq_postgresql_source.htm#:~:text=The%20following%20parameters,wal_level%20%3D%20logical" target="_blank" rel="noopener"><FONT face="courier new,courier">wal_level</FONT> must be set to&nbsp;<FONT face="courier new,courier">logical</FONT></A> in the node (primary, or replica).</SPAN></P> <P><SPAN>Hope this helps.</SPAN></P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>John.</SPAN></P> Wed, 01 Nov 2023 03:41:25 GMT john_wang 2023-11-01T03:41:25Z https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2133475#M7910 Tue, 31 Oct 2023 17:23:18 GMT https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2133475#M7910 jmiao 2023-10-31T17:23:18Z https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2133565#M7913 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/165296">@jmiao</a>&nbsp;,</P> <P>Welcome to Qlik Community forum and thanks for reaching out here!</P> <P>It's hard to tell this time based on the information provided. Could you please let us know detailed information about the secondary nodes?</P> <P>Please be aware of the following limitation:&nbsp;<A title="To capture changes from a secondary database, read/write privileges must be configured on the database" href="https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedReplicateHDD/PostgreSQL-Source/limitations_postgresql_source.htm#ar_postgresds_802412600_1652565:~:text=as%20a%20source-,Limitations%20and%20considerations,PostgreSQL%20read%20replica%20(in%20a%20High%20Availability%20environment)%20is%20not%20supported.,-For%20information%20about" target="_blank" rel="noopener">To capture changes from a secondary database, read/write privileges must be configured on the database</A>.</P> <P>BTW, the&nbsp;<SPAN><A title="wal_level in the postgresql.conf configuration file" href="https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/PostgreSQL/prereq_postgresql_source.htm#:~:text=The%20following%20parameters,wal_level%20%3D%20logical" target="_blank" rel="noopener"><FONT face="courier new,courier">wal_level</FONT> must be set to&nbsp;<FONT face="courier new,courier">logical</FONT></A> in the node (primary, or replica).</SPAN></P> <P><SPAN>Hope this helps.</SPAN></P> <P><SPAN>Regards,</SPAN></P> <P><SPAN>John.</SPAN></P> Wed, 01 Nov 2023 03:41:25 GMT https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2133565#M7913 john_wang 2023-11-01T03:41:25Z https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2134053#M7929 <P>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.</P> Thu, 02 Nov 2023 10:51:11 GMT https://community.qlik.com/t5/Qlik-Replicate/Is-it-possible-to-do-log-based-cdc-on-a-postgres-read-replica/m-p/2134053#M7929 dowre70 2023-11-02T10:51:11Z