Physical Replication Mechanisms in PostgreSQL

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

Physical Replication Mechanisms in PostgreSQL Physical replication slots were introduced to PostgreSQL with version , while logical replication slots were added beginning with version · The default

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

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

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

postgres create replication slot Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot

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