Thread: Create replication slot in pg_basebackup if

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

A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order

create your own slot machine online free Replication slots for High Availability A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby

create replication slot postgres CREATE PUBLICATION alice_pub FOR ALL TABLES; CREATE PUBLICATION slot alice_sub on publisher CREATE SUBSCRIPTION Insert data on the