ERROR: must be superuser or replication role to use

ERROR: must be superuser or replication role to use create replication slot This connects to the primary at primary-ip:6000 with the user we just created and takes a backup of it into the directory standby A new replication slot create replication slot postgres Register the Extract group with the database using the REGISTER EXTRACT command This will create a replication slot Make sure not to add the

create 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

create your own slot machine online free created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host Next, you need to create a replication slot A replication slot represents one specific stream of changes coming from a Postgres database