Inside logical replication in PostgreSQL: How it works

We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from

The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

postgres delete replication slot Slot Growth - Under the covers, a logical replication slot captures changes in the Postgres Write-Ahead Log and streams them in a human-

postgres replication slot restart_lsn will also be moved forward if possible For a physical replication slot, this function updates restart_lsn Share