PostgreSQL Logical Replication Advantage and Step by Step Setup

The following examples shows how logical decoding is controlled over the streaming replication protocol, using the program pg_recvlogical included in the

The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

postgres delete replication slot The beauty of Postgres logical replication is that not only other Postgres instances can serve as the consumer of a replication stream,

postgres create replication slot To enable this feature, you need to call the pg_create_logical_replication_slot() function or use the CREATE REPLICATION SLOTLOGICAL command