PostgreSQL Streaming Physical Replication With Slots

When replication slots is enabled, you might end up running out of disk space due to PostgreSQL trying to retain WAL files requested by a replication slot This

On the primary site's database node, start a PostgreSQL console session: sudo gitlab-psql · Find the name of the relevant replication slot · Remove the

drop replication slot postgres After completing your replication tasks, you should stop the replication process, drop replication slots, and turn off logical replication Before dropping

drops of gold slot The problem turned out to be order-of-events The publication has to be created before the replication slot or else it will not find the