C2PostgreSQL

CockroachDB to PostgreSQL

Replicator 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 Replicator relies on CockroachDB's transaction model for correctness when staging and applying mutations in transactionally-consistent modes.
• The replicator start flags would include two database connection strings:
  • --stagingConn 'postgres://staging.db:26257/'
  • --targetConn 'postgres://target.db:5432/target_db'