ERROR: must be superuser or replication role to use

Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments

Step 4: Create a logical replication slot · Connect your client to the RDS instance by using the db_admin account psql -h Endpoint of the RDS

postgres drop replication slot postgres #postgresql #database #opensource #data #datascience Patroni ( HA with

postgres create logical replication slot Create a new replication slot and mark it as used by this backend * * name: Name of the slot * db_specific: logical decoding is db specific; if the slot is