Re: Streaming Replication vs Logical
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Robert Treat <rob@xzilla.net>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-docs@lists.postgresql.org
Date: 2025-12-19T17:02:41Z
Lists: pgsql-docs
On Thu, Nov 27, 2025 at 12:16:01AM -0500, Bruce Momjian wrote: > On Mon, Nov 24, 2025 at 11:28:22PM -0500, Robert Treat wrote: > > > I took a look through some of the replication slot stuff and ISTM that it basically gets the streaming logical/physical replication distinctions correct, and I *think* > > > it gets the slot distinctions correct as well, but to the degree there might be some issue there, I think it could be addressed separately. > > > > > > > Hey Bruce, > > > > Your recent commit on this topic [1] reminded me of the patch from > > earlier this year meant to address some other areas where we are > > blurry about using streaming vs physical vs logical replication. I > > think (I might possibly still be jet lagged) I have updated the > > previous version of that patch against HEAD, attached, and bumping it > > up for review. > > Funny you found this patch, and I was thinking about it recently also > because of the fixes for physical vs logical replication. I will apply > this patch after sufficient review time, thanks. Great, patch applied, and commitfest updated. I apologize this dropped off my radar for so long. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.
Commits
-
doc: clarify when physical/logical replication is used
- 80f08a6e6a6c 19 (unreleased) landed
-
doc: clarify "physical" replication slot creation on the primary
- a5b69e30731f 19 (unreleased) cited
-
doc: reorder logical replication benefits in a logical order
- acbc9beaaed6 19 (unreleased) cited