Using PostgreSQL logical replication with Aurora
Using PostgreSQL logical replication with Aurora
pg_create_logical_replication_slot() is a system function for creating a logical replication slot pg_create_logical_replication_slot() was added in PostgreSQL
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 When PostgreSQL performs logical replication, the changes that are streamed to replicas are extracted from the WAL logs using logical decoding The decoded
das x boot slot A replication slot represents one specific stream of changes coming from a Postgres database and keeps track of how far a consumer has processed DROP REPLICATION SLOT replication_slot; CREATE REPLICATION SLOT replication_slot LOGICAL; Note: Make sure to replace replication_slot with the
![Using PostgreSQL logical replication with Aurora](10020.jpg)