Inside logical replication in PostgreSQL: How it works

Postgres logical replication concepts replication slot postgres Replication slots make sure that the new primary can carry on streaming changes from where the old primary left off This minimizes data loss replication slot postgres Reviving lost replication slots Hi, A replication slot can be lost when a subscriber is not able to catch up with the load on the primary and the WAL to

replication slot When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will