Troubleshooting PostgreSQL Streaming Replication Synchronization

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

Learn how to use replication slots with PostgreSQL's streaming physical replication drop a slot psql -c select * from pg_drop_replication_slot('replica

drop replication slot If you are not actively consuming a replication slot you should drop it To drop a replication slot called test_slot using SQL: SELECT

dropz slot demo Normally, the remote replication slot is created automatically when the subscription is created during CREATE SUBSCRIPTION, and it is dropped