On Fri, 2024-10-11 at 15:53 -0700, Paul A Jungwirth wrote: > Our docs seem to contrast "streaming replication" to logical, but > these are not really opposites. Sometimes when they say "streaming" > they mean "physical". > > Probably this is historical: at first physical replication was the > only kind of streaming we had. > > Personally this has caused me a lot of confusion. For example, > recently when I read "Synchronous replication (see Section 26.2.8) is > only supported on replication slots used over the streaming > replication interface," I took it to mean synchronous replication only > worked for physical replication, not logical.
What you are saying makes a lot of sense, and improving some of this is a good thing. Our current trminology is a mess. There are some places in the documentation that speak of physical vs. logical replication, while most places use the term "streaming replication" for physical replication. I myself consequently speak of "streaming replication" vs. "logical replication", even though both stream data. The protocol section of the documentation describes the "streaming replication protocol" and the "logical streaming replication protocol". This is confusing, and I am also sometimes confused in the way you described above. I think the mess is too well established to be really cleaned up. But adding some clarity is a good thing, so +1. Yours, Laurenz Albe
