[Solved] Which of the following best describes a key feature of logical replication in PostgreSQL? — Ans: It allows selective replication of specific tables or data changes. | PostgreSQL

PostgreSQL - Advanced Features

Which of the following best describes a key feature of logical replication in PostgreSQL?

AIt allows selective replication of specific tables or data changes.

BIt replicates the entire database cluster including system catalogs.

CIt only supports physical replication at the block level.

DIt requires identical hardware on publisher and subscriber.

Step-by-Step Solution

Solution:

Step 1: Understand logical replication scope
Logical replication allows replicating changes at the table level, not the entire cluster.
Step 2: Compare options
It allows selective replication of specific tables or data changes. correctly states selective replication of tables or changes. It replicates the entire database cluster including system catalogs. is incorrect as logical replication does not replicate system catalogs. It only supports physical replication at the block level. describes physical replication, not logical. It requires identical hardware on publisher and subscriber. is false; hardware need not be identical.
Final Answer:
It allows selective replication of specific tables or data changes. -> Option A
Quick Check:
Logical replication = selective table/data replication [OK]

Quick Trick: Logical replication replicates specific tables, not entire cluster [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following best describes a key feature of logical replication in PostgreSQL?