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

ERROR: must be superuser or replication role to use SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup · SHOW

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

postgres delete replication slot Logical Decoding Messages 101 Next, you need to create a replication slot A replication slot represents one specific stream of changes coming

Postgres logical replication slots are used to keep track of replication progress Every time a new version of sync

postgres create replication slot 1 Overview · 2 Install Postgresql-13 from source code · 3 Setup Primary Server · 4 Setup Standby Server · 5 Create replication slot on Primary

Create an instance with storage attributes for replication slots and schedule the first synchronisation Parameters: postgresql