Logical decoding - Azure Database for PostgreSQL

CREATE TABLE demo_table ; · select pg_create_logical_replication_slot; · psql dbname=postgres replication=

This creates a replication slot on a master database under the hood and starts listening to updates and commit them to the same tables on a

postgres replication slot A logical replication slot knows nothing about the state of the receiver Easy Steps to Set up PostgreSQL Logical Replication One of the

postgres delete replication slot In the context of logical replication, a slot represents a stream of changes that can be replayed to a client in the order they were made on the origin server