Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Replicate team,
We made a connection between src(Postgres sql) to tgt(DB2) and tried running a CDC task. But getting this error message and unable to proceed further. Please do the needful.
Error: RetCode: SQL_ERROR SqlState: 55000 NativeError: 1 Message: ERROR: logical decoding requires wal_level >= logical;
Organization: Toyota
Task: UTTMS_PG_DB2_CDC
PFA: Log
Thank you,
Lakshman
Thanks @Lakshman , on further looking at the log , it seems to be you are using Source endpoint 'Amazon RDS for PostgreSQL' .
Below is the user guide for it , please go thru the prerequisites and make sure you have set all the required permission for CDC as described in the document
Also the log says database version is 'PostgreSQL 14.2 ' .. Below are the supported version
PostgreSQL 9.6, 10.x, 11.x, 12.x, and 13.x
Please refer the below support matrix for the same
https://help.qlik.com/en-US/replicate/May2022/pdf/Replicate-Support-Matrix.pdf
Hope this helps
Thanks & Regards,
Arun
Hi @Lakshman
The rds.logical_replication parameter should be set to 1. Here is the documentation to setup postgres for RDS to enable CDC.
As noted by Arun, Replicate's support matrix does not include Postgres 14.x
Thanks @Lakshman , on further looking at the log , it seems to be you are using Source endpoint 'Amazon RDS for PostgreSQL' .
Below is the user guide for it , please go thru the prerequisites and make sure you have set all the required permission for CDC as described in the document
Also the log says database version is 'PostgreSQL 14.2 ' .. Below are the supported version
PostgreSQL 9.6, 10.x, 11.x, 12.x, and 13.x
Please refer the below support matrix for the same
https://help.qlik.com/en-US/replicate/May2022/pdf/Replicate-Support-Matrix.pdf
Hope this helps
Thanks & Regards,
Arun
Hi @Lakshman
The rds.logical_replication parameter should be set to 1. Here is the documentation to setup postgres for RDS to enable CDC.
As noted by Arun, Replicate's support matrix does not include Postgres 14.x