3 ms·
I find the explanation of logical and physical replication to be weird. Seems like only logical replication transfers changes. I have always thought physical r
by kroolik 3y ago
I find the explanation of logical and physical replication to be weird. Seems like only logical replication transfers changes.
I have always thought physical replication is replicating using WAL logs, which is a stream of changes. The logical replication would execute the queries on the replicating nodes, leaving WAL management to the replica.
This is also the reason why physical replication requires same pg versions (there may be diffs to the physical format of data in WAL), whilst logical replication uses domain language, which is independent from physical layout.