PostgreSQL
change data capture
TwinCommit captures changes from PostgreSQL by reading its transaction log directly, then delivers each committed transaction exactly once to any supported target. Logical decoding in, high-speed COPY + upsert out.
PostgreSQL
PostgreSQL 13–18 · Amazon RDS and Aurora · Azure Flexible Server · Cloud SQL · AlloyDB
- ✓wal_level = logical
- ✓REPLICATION privilege
- ✓Primary key or REPLICA IDENTITY FULL
Capture
How TwinCommit reads PostgreSQL
TwinCommit uses a logical replication slot with the built-in pgoutput plugin, so there is nothing to install on the server.
PostgreSQL source docs →Apply
How TwinCommit writes to PostgreSQL
Binary COPY into staging plus INSERT … ON CONFLICT, with the checkpoint in the same transaction.
PostgreSQL target docs →Replicate PostgreSQL to…
PostgreSQL connector FAQ
Which PostgreSQL versions does TwinCommit support?
+
PostgreSQL 13–18 · Amazon RDS and Aurora · Azure Flexible Server · Cloud SQL · AlloyDB.
Does TwinCommit install anything in PostgreSQL?
+
No. TwinCommit reads the PostgreSQL log and creates no triggers, tables or procedures in the source database.
How does TwinCommit write to PostgreSQL?
+
Binary COPY into staging plus INSERT … ON CONFLICT, with the checkpoint in the same transaction.
Replicate your first table in five minutes.
Download the free Developer edition, or have one of our replication engineers walk you through a migration plan.