Have you seen pgstream? https://github.com/xataio/pgstream
It is similar to pg_replicate and could be a good fit for streaming CDC data from Postgres. There is no built-in output plugin specifically for DuckDB but it might help you for building something lightweight and custom for your use case.
Binomial-Dist|1 year ago