Exploring versions of the Postgres logical replication protocol

The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more

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

postgres create logical replication slot postgres=# SELECT * FROM pg_replication_slot_advance; ERROR: replication slot physical_slot_1 cannot be advanced DETAIL: This

postgres replication slot In the context of PostgreSQL's logical replication, a “slot” is a mechanism used to keep track of the replication stream's progress Logical