Logical Replication in PostgreSQL

website postgres create logical replication slot In a logical replication scheme, high-level write operations are streamed from a master database server into one or more replica database postgresql replication slot PostgreSQL 10 came with the welcome addition of the logical replication feature This provides a more flexible and easier means to replicate

postgres create logical replication slot If you use a logical decoding plug-in which supports logical replication messages — like pgoutput since Postgres 14 — then that's all that's  As mentioned earlier, each subscription receives changes from a replication slot on the remote side Additional table  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

Share

Share

Link

Turn off sharing Copy link

See all details