Databases · Senior · Question 18 of 75
What does logical replication allow that physical streaming replication doesn't?
- 1Replicating without a network
- 2Faster replication of the entire cluster byte by byte
- ✓Correct answer: Replicating selected tables, between different major versions, and to subscribers that have their own writable tables
Explanation
It's used for zero-downtime major upgrades and for feeding other systems. Physical replication copies the whole cluster exactly and replicas are read-only.