Add or remove replication slots from a PostgreSQL database

Options · --create-slot Create a new logical replication slot with the name specified by --slot , using the output plugin specified by --plugin , for the

To configure replication slots, the Rivery user must be granted the REPLICATION role If the server does not already have a REPLICATION role, it can be created

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

create replication slot # add to on all nodes # include enough information in WAL for logical decoding wal_level ; logical # we need at least one replication slot, but