I am trying to create a source with postgres-cdc but encountering the error 'ERROR: QueryError: internal error: source cannot pass validation: INTERNAL: ERROR: relation 'mtx_transaction_header_2023_09' is already member of publication 'pub_header'. How can I resolve this issue?
Vijay Shankar
Asked on Oct 18, 2023
SELECT * FROM pg_publication_tables WHERE schemaname = 'public' AND tablename = 'mtx_transaction_header_2023_09' AND pubname = 'pub_header';