PostgreSQL DBA

High Availability & Streaming Replication

Question

Physical streaming replication versus logical replication: what differs and when should each be used?

Answer

Physical replication replays WAL for the whole cluster and supports standby promotion. Logical replication sends changes for selected published tables. Use physical replication for HA and read standbys; use logical replication for selective data distribution or migrations.

This is 5 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples