Logical Replication in PostgreSQL

ERROR: must be superuser or replication role to use create logical replication slot postgres A replication slot has an identifier that is unique across all databases in a PostgreSQL cluster Slots persist independently of the connection using them and create replication slot It creates a permanent logical replication slot on the publisher PostgreSQL persists the state of the replication slot information

create replication slot postgres In Database systems that use logical replication, replication slots are especially important for database replication