Glossary — in plain language

Replication


In plain English

Replication copies data from one PostgreSQL server (the primary) to one or more others (replicas/standbys). Physical replication copies everything byte-for-byte; logical replication copies chosen tables as row changes.

Why it matters

Replicas give you high availability (promote one if the primary dies) and read scaling (send read queries to replicas). The trade-off is replication lag and conflict handling.

Was this helpful?

← Browse the full glossary