Logical Replication in PostgreSQL by Özlem Güneş

PostgreSQL and later come with a feature called “replication slots” They can be used to make WAL archiving and streaming replication

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

start slot Replication slots are created independently from publications Publications to be used as a filter are specified when fetching changes stream

start_replication slot A logical decoding output plug-in You might need to install the output plug-in that you choose to use You must configure a replication slot that uses your