ERROR: must be superuser or replication role to use

The solution is replication slots, a feature provided by Postgres that ensures the primary server only discards WAL records after they have been received by the

ERROR: must be superuser or replication role to use A replication slot is a feature in PostgreSQL that ensures that the master server will retain the WAL logs that are needed by the replicas

The solution is replication slots, a feature provided by Postgres that ensures the primary server only discards WAL records after they have been received by the

slot machine to play The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more

PostgreSQL replication slot

postgresql drop replication slot Replication Slot Failover feature of ApsaraDB RDS for PostgreSQL If Replication Slot Failover feature of ApsaraDB RDS for PostgreSQL

Persistent Replication Slots: PostgreSQL uses a concept called “replication slots” for logical replication When you create a replication slot