Logical replication slots

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

Checking for replication slots Starting from PostgreSQL , it is also necessary and useful to check for leftover replication slots

postgresql create replication slot pg_stat_replication_slots: This is another PostgreSQL system view that provides information about the replication slots, including the replication lag You

postgresql drop replication slot In Postgres 16 the replication slots persist after a failover, which is very exciting! Our former standby gets promoted to become the