Failover of Logical Replication Slots in PostgreSQL

Failover of Logical Replication Slots in PostgreSQL replication slot Represents a physical replication connection to a PostgreSQL server PhysicalReplicationSlot Wraps a replication slot that uses physical replication replication slot is active for pid Postgres 12 highlight - Replication slot copy · Complete a base backup with pg_basebackup –slot using a permanent slot · Create one or more

replication slot is active for pid One statistics record of pg_stat_replication_slots is created for each logical replication slot described above Only one receiver may

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 Publication and replication slots When you configure your PostgreSQL source, you need to create a publication and a replication slot A publication is a set of