PostgreSQL 12: Copying replication slots

This is an example using wal2json A replication slot must be created on the PostgreSQL server SELECT * FROM

created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host

postgresql replication slot This blog introduced you to PostgreSQL Logical replication slots, their purpose, and the step-to-step setup introduction

postgres delete replication slot How it works When a logical replication slot is created, Postgres creates a snapshot of the current state of the database and records the consistent point