Logical decoding - Azure Database for PostgreSQL

Replicate data to an external Postgres instance postgres create logical replication slot Replication slots were introduced in Postgres They are a mechanism to accurately and durably keep track of how far a standby is lagging behind the primary postgres delete replication slot Export snapshot feature is also used while creating the replication slot If we specify the SNAPSHOT 'export' parameter when creating the

postgres drop replication slot Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur