Logical replication: stream changes out of PostgreSQL
What logical replication does, why teams use it to migrate a database with almost no downtime or to feed an analytics system, and where Voroa stands now.
What this covers
Logical replication publishes a stream of row-level changes from a PostgreSQL database, which another system subscribes to. It is used for two jobs above all. The first is migrating with almost no downtime: the new database subscribes, catches up while the old one is still serving, and the switch over becomes a matter of seconds rather than the length of a full dump and restore. The second is feeding a data warehouse or a search index continuously, instead of re-exporting the whole table on a schedule.
Logical replication is not available on Voroa today. Moving data in or out means a dump and restore, which requires a window where writes are stopped.