PostgreSQL Logical replication Practical use case

Failover of the logical replication slot​ Logical Replication Slots which exist on the primary are not available on standby replicas So if there is a

replication slots If you do not see the replication slot under the slot_name column then the slot does not exist There are two potential reasons for this

replication slot is active for pid Failure cause: The specified replication slot already exists in source database Handling suggestion: Delete the replication slot from the

replication slot already exists slots This is a perfect match for the use of temporary replication slots as many users are already using the stream mode of pg_basebackup