Logical replication

Crunchy Bridge allows you to set up logical replication to an external source. This may be useful for you to have a local copy of your data, on-prem replica, or stream data to data analytics / ETL / CDC platforms like Snowflake, BigQuery, Databricks, etc.

The default settings for logical replication on your provision are:

wal_level = logical
max_wal_senders = 10
max_replication_slots = 10

With Crunchy Bridge superuser rights, you can set up the replication publisher and subscriber and create replica slots. Be sure to also check the networking and permissions for your external sources to configure this. See more in the Postgres docs about logical replication.

Info

A more complete explanation of logical replication and set up instructions can be read in our blog post, Data To Go: Postgres Logical Replication