PostgreSQL replication client
It is possible to add a sgr
engine as a
logical replication client
to a production PostgreSQL database, occasionally committing the changes as new
Splitgraph images. This has many uses:
- Recording the history of the upstream database for audit purposes
- Using anonymized production data snapshots for integration testing
- Building derivative datasets with Splitfiles as an alternative to data warehousing.
For more information, see the replication client example.