Configuring PostgreSQL CDC Replication Slots and Publications

The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica

Setting slot_name to NONE means there will be no replication slot associated with the subscription Such subscriptions must also have both enabled and

postgresql replication slot Normally, the remote replication slot is created automatically when the subscription is created during CREATE SUBSCRIPTION, and it is

postgresql create replication slot If the max_wal_size parameter is too low, PostgreSQL may delete WAL data before it has been streamed to BigQuery, which can cause the