Log based change capture
Logical replication reads the write ahead log, so only changes move.
PostgreSQL
Polytomic connects PostgreSQL to your data warehouse, databases, and SaaS tools for database ETL and reverse ETL. Replicate tables into your data warehouse and other systems with log based change data capture, and write modelled data back into Postgres, without writing code.
Change capture from a replica
Supported on PostgreSQL 16 and later, keeping load off your primary.
Schema changes handled
New columns are picked up and destination tables migrate automatically.
Example workflows
Replicate production Postgres into your data warehouse
What you can sync
Move data between PostgreSQL and your data warehouse, databases, and SaaS tools, in both directions.
From PostgreSQL
Tables and views across schemas
Change data capture through logical replication
Custom SQL as a model source
Change capture from a read replica on PostgreSQL 16 and later
To PostgreSQL
Tables, created and migrated automatically
Create, update, create or update, and replace
Merges keyed on the source primary key
Soft deletes by default, hard deletes optional
How it works
Connect PostgreSQL and sync in either direction. Read tables into your data warehouse using logical replication so only committed changes move after the first load, or write modelled data back into Postgres from anywhere else in your stack.
On the destination side Polytomic creates the target tables, merges on the source primary key, and migrates columns as your selected fields change. New source columns are included automatically by default; new tables are not, so a schema addition never surprises you.
- Connect PostgreSQL directly, over an SSH tunnel, or via AWS PrivateLink
- Read tables and views, or write custom SQL as a model source
- Enable logical replication for log based change data capture
- Run change capture against a read replica on PostgreSQL 16 and later
- Write back with create, update, create or update, and replace modes
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic connects directly, through an SSH tunnel using a bastion host and private key, or over AWS PrivateLink. Client certificate authentication is available, which is unique to this connector among our relational databases. For change data capture you also need logical decoding enabled, a publication, and replication permission.
How to get connected
- 1Create a read only or replication role for Polytomic
- 2For change data capture, enable logical decoding and create a publication
- 3In Polytomic, navigate to Connections, then Add Connection, then PostgreSQL
- 4Enter host, port, database, and credentials, and configure SSL or SSH if needed
- 5Test the connection
- 6Select tables, choose a destination, set a schedule, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with PostgreSQL in minutes
No credit card required. Free trial available.