ERROR: must be superuser or replication role to use

ERROR: must be superuser or replication role to use create replication slot Logical replication slots are used to track the WAL positions on the primary server so that the standby server can request create replication slot DROP REPLICATION SLOT replication_slot; CREATE REPLICATION SLOT replication_slot LOGICAL; Note: Make sure to replace replication_slot with

create replication slot No more configuration is needed on the secondary server Finally, we created a replication slot What is the purpose of a replication slot in PostgreSQL?

create logical replication slot postgres It's about 10 tables in the schema, so that means 11 replication slots per subscriber cluster So in production could be up to 99 slots, let's The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node