ERROR: must be superuser or replication role to use

To set up native logical replication, logical decoding must be enabled on the primary instance, by setting _decoding=on on a Cloud SQL instance,

Step 1: Create a publication on the primary server · Step 2: Create a logical replication slot on the primary server · Step 3: Create a

postgres delete replication slot 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

postgresql drop replication slot We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from