A near-live copy of the primary fed by the WAL stream.

Postgres streaming replication keeps a warm standby

Physical streaming replication sends PostgreSQL WAL to a standby, which replays the records to maintain another copy of the cluster. It can send records without waiting for a whole segment to finish. This is distinct from logical replication of selected table changes. A running receiver and a reachable standby are useful health signals, but neither establishes that a particular committed row is already visible there. ...

August 10, 2027 · 6 min · XB Field Notes