PostgreSQL 12: Copying replication slots

website postgres create logical replication slot Options · --create-slot Create a new logical replication slot with the name specified by --slot , using the output plugin specified by --plugin , for the postgres replication slot The slot cannot be created as you are connected to a replica Common cloud implementations of PostgreSQL do not allow the addition of logical slots on replicas

postgres create logical replication slot 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   As mentioned earlier, each subscription receives changes from a replication slot on the remote side Additional table  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

Share

Share

Link

Turn off sharing Copy link

See all details