PostgreSQL Logical Replication

PostgreSQL Logical Replication postgres create logical replication slot The Postgres logical replication architecture is very simple It uses a publisher and subscriber model for data replication The primary data postgres create replication slot 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

postgres create replication slot Create logical replication slots on standby nodes Parameters: cluster – object containing stateful information for the cluster tags

postgres create logical replication slot A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby servers As a result, after a failover or To turn on logical replication for a newly created RDS for PostgreSQL DB instance