A Guide to Logical Replication and CDC in PostgreSQL

The postgresql_replication_slot resource creates and manages a replication slot on a PostgreSQL server Usage resource postgresql_replication_slot my_slot

Hey! I would want to create a replication slot in order to sync the changes in my database to GCP BigQuery When I try to run the command to

replication slot does not exist Inactive replication slots cause the accumulation of WAL files on the source DB instances WAL files might fill storage and cause outages Drop the subscription

replication slot already exists Each slot streams a sequence of changes from a single database Important: Replication slots and data loss A logical replication slot should only be used by a