C2PostgreSQL

cdc-sink can replicate a CockroachDB changefeed into a PostgreSQL database. The discussion in C2C applies, with the following notes:

• A separate CockroachDB instance must be used for staging, since cdc-sink relies on CockroachDB's transaction model for correctness when staging and applying mutations in transactionally-consistent modes.
• The cdc-sink start flags would include two database connection strings:
  • --stagingConn 'postgres://staging.db:26257/'
  • --targetConn 'postgres://target.db:5432/target_db'