I’m investigating a switch to CockroachDB from a Postgres instance, and one thing that we’re reliant on is pgsync for exporting cockroach data to elastisearch, with postgres as the single source of truth. I see CockroachDB has updated to support CDC, but it looks proprietary with no examples, and I’m not sure if its a replacement for what pgsync does.
Hi! CDC is an enterprise feature, but there are examples here: Stream Data Out of CockroachDB Using Changefeeds | CockroachDB Docs
I’m not familiar with
pgsync, but based on your description it does sound like CDC could be used for this.