A Guide to Logical Replication and CDC in PostgreSQL

Logical decoding replication slots are supported on only primary servers When there is a cluster of PostgreSQL servers, the connector can run on only the

Replication slots are marked as 'inactive' when the replication client connected to the slot disconnects Inactive replication slots cause WAL files to be

postgresql create replication slot The slot to be dropped must be inactive before it can be removed It is not possible to forcibly drop an active replication slot Change history PostgreSQL

postgresql replication slot A replication slot is a feature in PostgreSQL that ensures that the master server will retain the WAL logs that are needed by the replicas