Logical Replication on Standbys in Postgres 16

postgres create logical replication slot   Dan postgres drop replication slot

With the change in Postgres 16, when you're on a standby, you can actually create a logical replication slot There are a few mechanics around

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 pg_logical_slot_get_changes() is a system function returning a set of specified changes from the specified logical replication slot pg_logical_slot_get_changes

splashtastic slot review We can have multiple replication slots for a single database; each slot has its own state allowing different consumers to receive changes from In the context of PostgreSQL, logical replication employs a publishersubscriber model to mirror changes between PostgreSQL servers The primary