[Solved] Why does logical replication use replication slots on the publisher? — Ans: To keep track of which WAL changes have been sent to subscribers | PostgreSQL

PostgreSQL - Advanced Features

Why does logical replication use replication slots on the publisher?

ATo store the full copy of subscriber data

BTo keep track of which WAL changes have been sent to subscribers

CTo encrypt data during replication

DTo automatically create publications

Step-by-Step Solution

Solution:

Step 1: Understand replication slot purpose
Replication slots track the progress of WAL data sent to subscribers to avoid data loss.
Step 2: Eliminate incorrect options
Slots do not store subscriber data, encrypt data, or create publications automatically.
Final Answer:
To keep track of which WAL changes have been sent to subscribers -> Option B
Quick Check:
Replication slots track WAL progress [OK]

Quick Trick: Replication slots track sent WAL data for subscribers [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does logical replication use replication slots on the publisher?