Hi Team, I'm ingesting data from postgres to clickhouse getting the below mentioned error on ingestion

psycopg2.errors.InvalidParameterValue: option "write-in-chunks" = "1" is unknown

Hi @Syed Hamza Raza Kazmi! Can you share more context of where that error occurred? It's not clear to me if it's happening in tap-postgres or target-clickhouse (maybe it's using a postgres client?).

Hi @Edgar Ramírez (Arch.dev) Thanks for getting back i resolved it In postgres i have make change from this

SELECT * FROM pg_create_logical_replication_slot('pipelinewise_loan_service_raw', 'pgoutput');

to this:

SELECT * FROM pg_create_logical_replication_slot('pipelinewise_loan_service_raw', 'wal2json');