Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

pg_create_physical_replication_slot() is a system function for creating a physical replication slot pg_create_physical_replication_slot() was added in

When creating a subscription, the replication slot already exists In that case, the subscription can be created using the create_slot = false option to

create replication slot postgres pg_create_logical_replication_slot() is a system function for creating a logical replication slot pg_create_logical_replication_slot() was added in PostgreSQL

create logical replication slot postgres A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby servers As a result, after a failover or