Failover of Logical Replication Slots in PostgreSQL

The root of the problem is that the Logical Replication Slot which exists on the primary is not available in a physical standby Meanwhile

Exists in the Source Query the name of the streaming replication slot of the database object selected in the synchronization task

replication slot does not exist replication slot mysub on publisher CREATE SUBSCRIPTION The already exists dst=# SELECT currval, nextval('s_a_seq

replication slot is active for pid If for example PostgreSQL Native Replication is already in use and is using all of the currently configured replication slots, increase the value to allow for