PostgreSQL Logical Replication Gotchas

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

PostgreSQL Logical Replication Gotchas True if this is a temporary replication slot Temporary slots are not saved to disk and are automatically dropped on error or when the session has finished

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

drop slot This simply introduces two new options allowing to create or drop a physical replication slot, respectively –create-slot and –drop-slot The

Decrease quantity for drop replication slot postgres Increase quantity for drop replication slot postgres Add to cart drop replication slot postgres

drop slot safe Normally, the remote replication slot is created automatically when the subscription is created during CREATE SUBSCRIPTION, and it is dropped

Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments