Create replication slots to enable the CDC feature

postgres create replication slot   Dan postgresql drop replication slot

How it works When a logical replication slot is created, Postgres creates a snapshot of the current state of the database and records the consistent point

Logical replication slots are used to track the WAL positions on the primary server so that the standby server can request Replication slots are created independently from publications Publications to be used as a filter are specified when fetching changes stream

best slot canyons in utah PostgreSQL and later come with a feature called “replication slots” They can be used to make WAL archiving and streaming replication It is important to remove unused replication setups, since the underlying replication slots in PostgreSQL forces the server to keep all the data needed to