Document the logical replication setup using pg_base_backup for

Document the logical replication setup using pg_base_backup for replication slot already exists You might already have this collection installed if you are using the ansible package Remove physical_one slot if exists become_user: postgres community replication slot postgres already exist Multiple subscribers can all connect to the same publication First part of LSN of the institution replication slot is

replication slot postgres Replication slots were introduced with PostgreSQL and are designed to ensure that any standby connected to the primary using a replication slot will always

replication slot is active for pid Here are some scenarios: When creating a subscription, the replication slot already exists In that case, the subscription can be created using the create_slot replication slot mysub on publisher CREATE SUBSCRIPTION The already exists dst=# SELECT currval, nextval('s_a_seq