ERROR: must be superuser or replication role to use

the master doesn't create the replication slot This doesn't happen at every restart but randomlyinconsistent In the slave postgres logs:

Configure logical replication using the slot⁠ ​ · Create a publication on the source cluster: CREATE PUBLICATION publication_name> FOR TABLE

create logical replication slot postgres 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

create replication slot SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup · SHOW